Non-clustered indexes can be numerous in SQL Server 2008 I remember from my Sybase days that SQL Server tables could support up to 255 indexes. One clustered index and 254 non-clustered indexes. In ...
Analyzing the data, I soon realized the real reason was the LACK of data. This table had only 504 rows and only consumed 13 data pages in the clustered index. The non-clustered indexes used only 2 or ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback