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...
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
There is no easy yes or no to this question. Do you face any issues that you attribute to the fragmentation?
