i have a table, with one non Clustered index on id.
i maje quries on this table on the datetime coulmn (table has 1.8 million rows and grow all the time)
the search is very fast (no index on this column).
when i look at the execution plan ot show it scaned the clustered index.
- why it scanned the clustered index why the "where" caluse was on another column.
- how come the seach so fast? because of the statistics?
this is the estimated execution plan i see :