index basic

• selvakumar.sms

  SSC Eights!

  Points: 895

  More actions

  April 22, 2012 at 9:16 pm

  #255235

  hi all

  i am very new to sql, i cant understand many things especially INDEX concept.please give clear view of index.

  1 . difference between clustered and non-clustered index.

  2. single column index and multiple column index.

  3.Advantage of index.

  plz give with examples. plz.

  thanks:-P:-P

  --------------------------------------------------------

  I am Learner -- SQL

• dogramone

  Hall of Fame

  Points: 3216

  More actions

  April 22, 2012 at 9:28 pm

  #1477242

  Books on-line, the SQL help files, cover all of this and more. There are also articles on this site on index basics.

  Search the site or try this link http://qa.sqlservercentral.com/articles/Indexing/68439/

• vinu512

  SSCoach

  Points: 15729

  More actions

  April 22, 2012 at 10:46 pm

  #1477254

  You'll get whatever you need to know about Indexing at the following link:

  Stairway to SQL Server Indexes[/url]

  Vinu Vijayan

  For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉