Community

SQL SERVER – Heaps, Scans and RID Lookup

(Pinal Dave) Today we will discuss a question which I was recently asked by my client during the Comprehensive Database Performance Health Check. The question was do heaps are very bad and always force a table scan?