Script to find out Heap Table/Table without clustered Index
Posted by Jugal Shah on November 17, 2011
Heap Table: Table without a clustered index is called Heap Table. You can find out the Heap Table by querying the sys.indexes or sys.partitions against the index_id column.
select OBJECT_NAME(object_id),*
from sys.indexes where index_id = 0
Select OBJECT_NAME(object_id),*
from sys.partitions where index_id = 0
18.520469
73.856621
Like this:
Be the first to like this post.
This entry was posted on November 17, 2011 at 5:57 am and is filed under SQL Scripts, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2011 (Denali).
Tagged: Heap Table, Index, Jugal Shah, SQL Optimization, SQL Script, SQLDBPool. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
