New answers tagged


Don't get caught up the the physical/logical aspect. It is just terminology and what you mean by "physical" is just a matter of abstraction level in the end. IMO, the term "physical" is meaningless, confusing and should be avoided in this context. Both types of indexes are B-Tree indexes. Make sure you understand what this is and that you ...


The clustered index is the logical ordering of the data of the table itself into a B-Tree structure. Without a clustered index, the table itself is then stored in a Heap data structure, logically. This article, Clustered Index vs Heap in SQL Server, goes into the structural differences between the two. One other thing to note is the clustered index also ...


Remember that non-unique, non-clustered indexes always include clustered index keys as index key columns. So your premise is faulty. The partition key is present in the index, and it may be placed on the same partition scheme as the clustered index.


In most cases your non-clustered indexes were added after the fact to address a certain query, which might be very important to your business/application. As usual the answer is, it depends on the importance of the queries utilizing the indexes (be it clustered on non-clustered). If you can, restore the database to a development server, and run the 3x Ola ...

Top 50 recent answers are included