Index Benefits and Side Effects. A table without a clustered-index is called a “heap table”. A heap table has not its data sorted. The SQL server has to scan the. Jan 21, 2010. Difference between composite index and covering index hi guys! i just want to know the difference between the composite index and covering index (both se. I'll cover the following topics in the code samples below: SQL Server…