Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kalpana19
Starting Member
2 Posts |
 Posted - 2008-04-09 : 14:34:40
|
| What is Indexes in SQL Server? Where we use ?? How to use? I need little explanation about this topic with any sample code.Thanks in advance. |
|
|
kamal.A
Yak Posting Veteran
70 Posts |
Posted - 2008-04-09 : 14:37:00
|
| Haiindexes operate 'behind the scenes' in support of the database engine. However, creating the proper index can drastically increase the performance of an application.And also refer from http://www.odetocode.com/Articles/70.aspxkamal. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 14:41:10
|
| Check www.SQL-Server-Performance.com They have really good article on indexes for 2005(Online reindexing as well). |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-09 : 14:46:36
|
| Indexes in SQL Server are like indexes of a book. It facilitates speedy retrieval of data from tables. Its created on a column in table and facilitates data retrieval based on that column value. You have basically four types of indexes in SQL Server.Clustered,Non Clustered,Covering & XML indexes. Clustered index means basicaly the table will be physically sorted on the column on which it is defined. You can have only 1 clustered index. Non clustered index means the information about index is held outside of table. you can have multiple non clustered indexes on a single table. Covering indexes are special type of indexes where extra information will be held in index to cover a particular search pattern. more details on all these can be read from BOL. XML indexes are indexes created with xml nodes so as facilitate searching in xml. |
|
|
|
Kalpana19
Starting Member
2 Posts |
Posted - 2008-04-09 : 14:48:23
|
Thanks for the reply. I'll go through the link...quote:
Originally posted by kamal.A
Haiindexes operate 'behind the scenes' in support of the database engine. However, creating the proper index can drastically increase the performance of an application.And also refer from http://www.odetocode.com/Articles/70.aspxkamal.
|
|
|
|
|
|
|
Indexes in SQL Server 2005