I recently found that a couple of my tables in SQL Server 2008 R2 with no clustered indexes defined. However, there are non-clustered indexes defined (so basically they're on HEAP).
After I did some searching, I learned that some select statements were using a filter on the columns defined (in non-clustered indexes).
My question is not having a clustered index on these tables affect their performance?
October 11, 2013 12:46 PM
October 15, 2013 11:19 AM