0

I come to know that this is used to speed up data retrieval..I like to know more about it .Thanks .

arifCoder
  • 344
  • 1
  • 4
  • 12
  • For simple, It is `Keys` that refer to each of your records. It is sorting and used to help searching your records faster. For more, use your google skill. – Pham X. Bach Sep 23 '16 at 04:27
  • 1
    there are many questions in SO and DBA.SE which covers the topic,start with them and if you have any question in those ask – TheGameiswar Sep 23 '16 at 04:48
  • http://use-the-index-luke.com/ –  Sep 23 '16 at 06:07

1 Answers1

1

Indexing is a way of sorting a number of records on multiple fields. Creating an index on a field in a table creates another data structure which holds the field value, and pointer to the record it relates to. This index structure is then sorted, allowing Binary Searches to be performed on it.

Sahil Manchanda
  • 9,812
  • 4
  • 39
  • 89