SQL Server Performance

nonclustered, unique located on PRIMARY

Discussion in 'SQL Server 2005 General Developer Questions' started by ashish.johri2007, Mar 12, 2007.

  1. ashish.johri2007 New Member

    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
  2. dineshasanka Moderator

  3. ashish.johri2007 New Member

    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
  4. Adriaan New Member

    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.
  5. Roji. P. Thomas New Member

    quote:Originally posted by ashish.johri2007

    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.
    You can insert one NULL value.

    Roji. P. Thomas
    SQL Server MVP
    http://toponewithties.blogspot.com

Share This Page