.Net Database Interview Question:

Explain What is indexing?

Submitted by: Administrator

An index
1. is sorted by key values, (that need not be the same as those of the table)
2. is small, has just a few columns of the table.
3. refers for a key value to the right block within the table.
4. speeds up reading a row, when you know the right search arguments.
Submitted by: Administrator