In this post, I am sharing one of the script for a Database Administrator to find SQL Server Heap Tables which are not having a clustered index.
A Table without a cluster index is called as Heap Table and Data is stored in the Heap without specifying an order.
Sometimes, database developer forgets to apply cluster index on a particular table and after that the same table may have a lot of data which affect to query performance without having a cluster index.
Below is a script to find all Heap Table of a Database:
OBJECT_NAME(object_id) AS TableName
,type_desc AS TableType
WHERE index_id = 0