Questions tagged [scan]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
171 views

How does a column-oriented DBMS filter on multiple columns?

I'm learning how column-oriented DBMS / "columnars" work for OLAP situations. Let's say we have a log of millions of transactions with 3 columns: timestamp, shop, product, and we want to ...
0
votes
2answers
489 views

Delete cascade produce scan intead of index seek

I have two tables in my database. TableA : 1427877 rows TableB : 339939000 rows TableB has a foreignkey column in TableB (TableB.foreignId). It has Delete On Cascade ON. The problem is when I ...