Question : I have a large table with 7.5 billion rows and 5 indexes. When I delete roughly 10 million […]
Tag: nonclustered-index
Why is my index not being used in a SELECT TOP?
Question : Here’s the run-down: I’m doing a select query. Every column in the WHERE and ORDER BY clauses are […]
Index and Heap table storage on disk
Question : I have a few questions on tables and Indexed tables and its storage, Here is my first image […]
Creating non-clustered index on large table fills transaction logs
Question : Using SQL Server 2016, I’m trying to create a non-clustered covering index on a table in my database […]
non clustered index coverage with INCLUDED columns
Question : If I have two indexes: IDX_1 = (COL1), (COL2) DESC IDX_2 = (COL1) INCLUDE (COL3) will a single […]
Any reason to have both an index with included columns and one without?
Question : I am looking through a few slow running queries on a database that has under gone significant development […]
Unique Non Clustered Column in Partitioned table
Question : We have partitioned one of our SQL Server tables on a Clustered Index datetime column, we have a […]
Space consumed by a column in non clustered index
Question : I m planning to add a key column index in one of the existing non clustered index in […]
Can a PRIMARY KEY constraint (with a NONCLUSTERED INDEX) check for only certain values?
Question : Can I set a (logical) PRIMARY KEY constraint, served by a (physical) NONCLUSTERED INDEX, so that it only […]
Using an index when leading column is not in the predicate
Question : Are there any circumstances when an index could be used when not all the index columns are included […]