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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!