SQL Server Performance

heap index

Discussion in 'SQL Server 2005 General DBA Questions' started by priyaram, Oct 26, 2007.

  1. priyaram New Member

    when i query the database tables to find out the information about indexes , i got 3 types of indexes , clustered , non clustered and heap.
    i am familier with clustered and non clustered , but about heap...
    i searched in google and mostly they are saying table without clustered is called heap..
    where can i get more info regarding the heap index.. and also if i want to reindex the table with heap shall i use the stored proc that was found in the below link...
    http://www.sqlmag.com/Article/ArticleID/96059/sql_server_96059.html
    since it covers the reindex and update statistics on all tables with is having clusterd mnon clustered and heap indexes...
  2. MohammedU New Member

    A heap is a table without a clustered index. Heaps have one row in sys.partitions, with index_id = 0 for each partition used by the heap. By default, a heap has a single partition. When a heap has multiple partitions, each partition has a heap structure that contains the data for that specific partition. For example, if a heap has four partitions, there are four heap structures; one in each partition.
    http://msdn2.microsoft.com/en-us/library/ms188270.aspx
    http://msdn2.microsoft.com/en-us/library/Aa964133.aspx
  3. ronrysanek New Member

    Should I be concerned with heaps that have very high fragmentation?
  4. FrankKalis Moderator

    There is no easy yes or no to this question. Do you face any issues that you attribute to the fragmentation?

Share This Page