what is clustered index and non clustered index Forum Locked Printer Friendly Author Topic sethumail Starting Member 2 Posts Posted – 02/26/2005 : 06:38:11 Hi, Define clustered index and non clustered index?

0
Posted

what is clustered index and non clustered index Forum Locked Printer Friendly Author Topic sethumail Starting Member 2 Posts Posted – 02/26/2005 : 06:38:11 Hi, Define clustered index and non clustered index?

0

robvolk SQLTeam MVY/MIA USA 11745 Posts Posted – 02/26/2005 : 07:43:50 From Books Online:quote:Using Clustered Indexes A clustered index determines the physical order of data in a table. A clustered index is analogous to a telephone directory, which arranges data by last name. Because the clustered index dictates the physical storage order of the data in the table, a table can contain only one clustered index. However, the index can comprise multiple columns (a composite index), like the way a telephone directory is organized by last name and first name.quote:Using Nonclustered Indexes A nonclustered index is analogous to an index in a textbook. The data is stored in one place, the index in another, with pointers to the storage location of the data. The items in the index are stored in the order of the index key values, but the information in the table is stored in a different order (which can be dictated by a clustered index). If no clustered index is created on the table, the rows ar

Related Questions