This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a script for a Database Administrator to find SQL Server Heap Tables which are not having a clustered index.
A Table without a clustered index is called as Heap Table and Data is stored in the Heap without specifying an order.
I have also published one article on, What is Heap Table?
You can visit this article here:
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 the query performance without having a clustered index.
Below is a script:
1 2 3 4 5 6 7 |
SELECT OBJECT_NAME(object_id) AS TableName ,type_desc AS TableType ,allow_row_locks ,allow_page_locks FROM sys.indexes WHERE index_id = 0 |