I have created one table with 80000 records with
Cluster Index on
CustomerID column. When I queried the following statements the execution plan behaves in differently. Can anyone clarify the same.
select * from customer
Showing Cluster Index Scan, So this is correct.
select * from customer where CustomerID=80000
Execution plan shows ClusterIndex Seek, So this is correct.
select * from customer where CustomerID between 1 and 70000
Execution plan still shows ClusterIndex Seek why?
As per the statistics the row count is 90% then the optimizer have to use 'ClusterIndex Scan' but it's using 'Cluster Index Seek' Why? All statistics are up to date and I have checked the Estimated row and actual rows are same then why the optimizer choose 'Cluster Index Seek' For getting 90% of rows among total records.