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 : 4005 | 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

Reply | Reply with Attachment

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

0	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

0	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

0	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

0	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

Latest Posts