Saturday, September 11, 2010

What is Index?

A database index is a data structure which use to improve the speed of operations on a database table.

It’s a physical structure containing pointers to the data. Indices can be created using one or more columns of a database table. Indices are created in an existing table to quickly and efficiently lookups.

It is possible to create an index on one or more columns of a table, and each index is given a name. Best way to improve performance in a database application is effective indexes.

There are two type of index available.

1. Clustered index

Clustered index are physical form of sorting. Therefore only one clustered index can be created on each table because the data rows themselves can only be sorted in one order.

2. Non Clustered index
Non clustered indexes are logical form of sorting. Therefore more than one Non clustered indexes can be created on each table.

No comments: