SQLServerCentral » Latest topics
Why SQL Server is not using non-clustered index
In SQL server 2008R2, Table having Non-clustered index and table contains 2 crore records, while executing "Select count(*) from table name" it going for table scan, its not using non clustered index. Why index is not used?
No comments:
Post a Comment