Index - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Index

Author

Topic

edcas
Starting Member

5 Posts

Posted - 2005-08-17 : 02:20:53

hi,

i need help on this as i'm getting confuse on the clustered and nonclustered index topic. wat r the main difference between these 2 CREATE INDEX statement as i've found that both are actually serving the same functionality. Both allow duplicate and null values.

CREATE NONCLUSTERED INDEX ed_id_CL1 ON ed_table (ed_id)

CREATE CLUSTERED INDEX ed_id_CL2 ON ed_table (ed_id)

TQ

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-17 : 02:25:03

See if these help you
http://www.sql-server-performance.com/gv_index_data_structures.asp
http://www.sql-server-performance.com/optimizing_indexes.asp

Madhivanan

Failing to plan is Planning to fail

KidSQL
Yak Posting Veteran

88 Posts

Posted - 2005-10-06 : 13:40:32

madhivanan,

I find these links to be very helpful.

I find your contributions to this forum very valuable, as usual.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-07 : 00:27:21

quote:
Originally posted by KidSQL

madhivanan,

I find these links to be very helpful.

I find your contributions to this forum very valuable, as usual.

Thanks

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources