what is index ?

• spectra

  SSCarpal Tunnel

  Points: 4120

  More actions

  July 5, 2006 at 11:46 pm

  #69127

  what is index of the database ?

  i come accross this word very often.

  does all the table has some internal index ?

  or whats the indexing of database ?

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  July 6, 2006 at 4:17 am

  #647702

  Hi,

   

  A Microsoft® SQL Server™ 2000 index is a structure associated with a table or view that speeds retrieval of rows from the table or view. An index contains keys built from one or more columns in the table or view. These keys are stored in a structure that allows SQL Server to find the row or rows associated with the key values quickly and efficiently.

  Please review the following links for more info:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_8sit.asp

  C:\Documents and Settings\mamin\Desktop\my_folder\persono\An Introduction to Clustered and Non-Clustered Index Data Structures.htm

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_8sit.asp

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_8sit.asp

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_8sit.asp

  Hope this will help you.......

   

   

  "More Green More Oxygen !! Plant a tree today"