Reason for columns made as non-clustered Index? [Resolved]

hI

there are two reasons for that

1.Columns that undergo frequent changes
2.Wide keys

refer this link for more details

http://msdn.microsoft.com/en-us/library/aa933131%28v=sql.80%29.aspx

R D Patel

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

Refer this url

http://msdn.microsoft.com/en-us/library/ms177484%28v=sql.105%29.aspx

.

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

Hi ...

Please refer the below link.

http://www.codeproject.com/Articles/39006/Overview-of-SQL-Server-2005-2008-Table-Indexing-Pa#what_is_index

Regards,

Arul R
arul44.ece@gmail.com

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

We can set only one column as a clustered index and can not set more than one column.
We can set non-clustered index for more than one column in a table.
In default clustered index will be created while set up primary key for a column then we can not set clustered index for other column in that table so here we can set non-clustered index
non-clustered index column logically arranged so while use this column in where condition it gives better performance.

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

Hi

here is some more information about cluster and non cluster index

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

http://blog.sqlauthority.com/2009/02/21/sql-server-observation-effect-of-clustered-index-over-nonclustered-index-2/

R D Patel

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

rebuilding a non-clustered index
doesnot affect actual table space, but a clustered index "includes" the
data pages, hence the change in space usage when rebuilding the index

look at dis url
http://msdn.microsoft.com/en-us/library/aa933130%28v=sql.80%29.aspx

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