Sql Index

Question

Post reply

Sql Index

vijayarani87.s

SSC Eights!

Points: 890
More actions
September 28, 2012 at 12:12 am

#267395

Hi guys,
Can anyone help me in explaining Clustered and Non Clustered index?
I never used any of this in my project. But i would like to know in which scenario I can use.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

demonfox SSCertifiable Points: 6289 More actions · Answer 1

cool ..

start with reading this one ; it starts with the basics and may be something more

http://msdn.microsoft.com/en-us/library/aa174541(v=sql.80).aspx

....

go to the stairways to indexes in SSC ; that's a wonderful series of articles..

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

vivekkumar341 Say Hey Kid Points: 681 More actions · Answer 2

Hey please go through the below mentioned link.

http://www.codeproject.com/Articles/173275/Clustered-and-Non-Clustered-Index-in-SQL-2005

Ant-Green SSC Guru Points: 113499 More actions · Answer 3

http://www.sqlservercentral.com/Authors/Articles/Gail_Shaw/148127/

Gail has wrote some good articles on indexes, use the above link and read the "Introduction to Indexes" articles.

Suresh B. SSC-Insane Points: 22986 More actions · Answer 4

vijayarani87.s (9/28/2012)
I never used any of this in my project.

You might have used them unknowingly!

For example, when you created a Primary Key constraint, by default it creates a clustered index.

When you created an Unique constraint, it creates a nonclustered index.

But i would like to know in which scenario I can use.

You create indexes to improve the performance of queries, especially SELECT statements.

vijayarani87.s SSC Eights! Points: 890 More actions · Answer 5

Hi suresh thank u very much for ur explanation.

Thank U guys... The link provided by u helped me a lot. :):-)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

vivekkumar341 (9/28/2012)

Hey please go through the below mentioned link.

http://www.codeproject.com/Articles/173275/Clustered-and-Non-Clustered-Index-in-SQL-2005%5B/quote%5D

I'd recommend not reading that. It has some fundamental errors in it.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass