what is index?and types how to create index in sql with example

Posted by Venky.Net under Sql Server on 4/27/2012 | Points: 10 | Views : 3063 | Status : [Member] | Replies : 4
hi every body good morning
what is index?and how to create a index in sql with example?and types of index




Responses

Posted by: Hariinakoti on: 4/27/2012 [Member] Starter | Points: 25

Up
0
Down
Hi Venky ,
Please refer below link it is very useful to u....
http://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/

Thanks & Regards
Hari

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 5/19/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,

An Index is just like a book to Execute fast in your query.
Types:
clustered index
non clusteredIndex.

Regards
Sriram.R


sriram

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/18/2012 [Member] Bronze | Points: 25

Up
0
Down
Indexs are two types
1.Clusterd index
2.Non clustered index
Refer this link

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_50 10.htm[/LINK]

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/18/2012 [Member] Bronze | Points: 25

Up
0
Down
Refer this link too
http://www.sqlteam.com/article/sql-server-indexes-the-basics

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response