April 9, 2010 at 5:42 am
My understaning is non clustered index maintain catelog to have address of physical data.
For example, if I have 4 columns in where clause which are combined and created as one non clusterd index.In this case,I want to know that this non clustered index will refer clustered index(primary key) or not?
The thing is,here primary is not part of where clause.please clear my doubts.
April 9, 2010 at 6:29 am
amalanto (4/9/2010)
I want to know that this non clustered index will refer clustered index(primary key) or not?
If a table is having clustered index, the non-clustered keys point to the clustered index and not directly to the table data.
Refer: http://msdn.microsoft.com/en-us/library/aa174537(SQL.80).aspx"> http://msdn.microsoft.com/en-us/library/aa174537(SQL.80).aspx
April 9, 2010 at 8:06 am
amalanto (4/9/2010)
I want to know that this non clustered index will refer clustered index(primary key) or not?
Look for Key look up in Exec plan. if Non clus index doesnt able to fullfill requireement of query , it will approach for Clus. index ( by Key look up )
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply