SQL Server Performance Forum – Threads Archive

nonclustered, unique located on PRIMARY

Hello sir, I have defined Purchase_Owner_Id_Unq as an index with index_description as “nonclustered, unique located on PRIMARY” and index_keys is ‘Ownr_ID#%92. While Ownr_ID is a nullable column in my table. What does this index_description mean? Any pointers? Ashish Johri

---

it is the descirption of the index http://msdn2.microsoft.com/en-us/library/ms187335.aspx —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

HI, I got response from my senior. If there is any nullable column and we create any index on this saying “unique” then this takes only unique values. This says “ON Primary”…What exactly this is? Is this some FILE Group?
Ashish Johri

---

Yes, it will be created on the primary file group for the database. It’s not that complicated, really – check the CREATE INDEX syntax in BOL.

---

You can insert one NULL value. Roji. P. Thomas
SQL Server MVP
http://toponewithties.blogspot.com

---

]]>