Whats the use of creating the index

[garunagiri]

Hi all,
I created index for a table.
But I don't know what's use of that.

can we use the index as like stored procedures or like query statements?..

Guidance please.

Thanks,
Arunagiri Gunasekaran.

[almaz]

I created index for a table.
But I don't know what's use of that....

Indexes are used to effectively select data based on some filter criteria.
You don't have to USE index manually, SQL Server will decide itself whether it is better to use particular index when searching for records in the table

[blackjack2150]

Indexes are used to improve the speed of some searching or sorting operations which involve the fields on which you've defined your indexes on.

[garunagiri]

Indexes are used to effectively select data based on some filter criteria.
You don't have to USE index manually, SQL Server will decide itself whether it is better to use particular index when searching for records in the table

Thanks almaz. Its clear for me about the index.

Now can u say about the use and difference between clustered and non-clustered index ?

[almaz]

Now can u say about the use and difference between clustered and non-clustered index ?

I guess Google can answer this question better than me :).