What is a table called, if it does not have neither Cluster nor Non-cluster Index?..

Archer · #1 07-18-2007, 09:53 PM

What is a table called, if it does not have neither Cluster nor Non-cluster Index? What is it used for?

Murali · #2 07-18-2007, 10:05 PM

Hi,

The Table that dont have a Non-Clustered Index or Cluster Index is called Heap [Unindexed Table].

Heap Tables are used for Storing large amount of data.

H2o · #3 07-18-2007, 11:19 PM

Unindexed table or Heap. Microsoft Press Books and Book On Line (BOL) refers it as Heap.
A heap is a table that does not have a clustered index and, therefore, the pages are not linked by pointers. The IAM pages are the only structures that link the pages in a table together.
Unindexed tables are good for fast storing of data. Many times it is better to drop all indexes from table and than do bulk of inserts and to restore those indexes after that

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hyper-V R2 - Failover Cluster Cluster Name resource fails to come online	arjkhanna	Operating Systems	4	04-07-2009 02:01 AM
Row order in cluster & non-cluster index?	prasath	Database Support	1	08-07-2007 11:35 PM
Cluster & Non cluster index	prasath	Database Support	1	07-16-2007 04:29 AM
cluster index in Oracle	vigneshgets	Database Support	1	07-10-2007 06:22 AM
MySQL Cluster	Jeyaseelansarc	Database Support	0	05-10-2007 12:30 AM