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

Posted by Oswaldlily under Sql Server on 7/17/2012 | Points: 10 | Views : 1098 | Status : [Member] | Replies : 6
V have made one columns as non-clustered index..But dont know reason why I have to make it so??
Can anyone explain me for reason it made as non-clustered index?




Responses

Posted by: Patel28rajendra on: 7/25/2012 [Member] Starter | Points: 50

Up
0
Down

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

Posted by: Ranjeet_8 on: 7/17/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
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

Posted by: Arul44ece on: 7/17/2012 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Karthikeyanp365 on: 7/25/2012 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Patel28rajendra on: 7/25/2012 [Member] Starter | Points: 25
Posted by: Ranjeet_8 on: 7/25/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
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

Login to post response