Index Tip : Clustered or non clustered | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Index Tip : Clustered or non clustered

If i have Unique Constraint on col A on table AA and i have non clustered index built on it … would it give me result like i have created Clustered Index ? hsGoswami
[email protected]
Can you be a bit more specific?
I don’t understand your question. [?] —
Frank Kalis
SQL Server MVP
http://www.insidesql.de
Yes Sir,
i have a Database DB1 and in DB1 database i have table AA and in Table AA i ahve a column A,B and C… out of these three column i have Unique Constraint on column A and on Column A i have created non-clustered index…. now the question is the outcome of this it will gives result like column with Clustered Index ? hsGoswami
[email protected]
You mean that it is sorted in the order of the keys?
Yes, this will be the same, but it won’t affect the physical storage of the data, like in case of a clustered index. —
Frank Kalis
SQL Server MVP
http://www.insidesql.de
that means it will treated as Clustered index ? though i dont have clustered index just becoz i have uniqued constraint and non clustered index on the column..!!! m i right sir ? hsGoswami
[email protected]
No! It isn’t treated as clustered index. A clustered index will affect the physical storage of the rows in the table, while your nonclustered index will only store the indexed columns in order. This happens in a separate physical structure and won’t affect any storage of the data in the underlying table. You might want to read BOL to understand the architecture of both index types. Here’s also a good resource:http://support.microsoft.com/default.aspx?scid=kb;EN-US;325024 —
Frank Kalis
SQL Server MVP
http://www.insidesql.de
Thanx sir, i got it. hsGoswami
[email protected]
]]>