SQLServerCentral » Latest topics
why query optimizer is using Non-clustered index for count(*) operation
why query optimizer is using Non-clustered index scan for "select count(*)" operation and Clustered Index scan for "select * from tablename" operation.
This table contains both clustered and non clustered Index. The column "file_No" is added to
This table contains both clustered and non clustered Index. The column "file_No" is added to
No comments:
Post a Comment