Post reply

Can we created composite NonClustered index on the columns INTETER and VARCHAR ?

  • October 30, 2014 at 5:31 am

    #291993

    Can we created composite NonClustered index on the columns INTETER and VARCHAR ?

    can you please tell me what r the drop backs if i create like this ?

  • October 30, 2014 at 5:32 am

    #1755739

    Yes you can.

    Drawbacks?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 30, 2014 at 5:51 am

    #1755744

    kbhanu15 (10/30/2014)

    can you please tell me what r the drop backs if i create like this ?

    Your question is too vague to be answered.

    Explain your scenario, what you want to achieve and why you think there might be any downsides.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply