locked
How many non cluster index are there for a table? RRS feed

  • Question

  • Hi,

    How many non cluster index available in a table?

    Regards

    JHKiran.

    Saturday, April 6, 2013 5:13 AM

Answers

All replies

  • Hi,

    You don't mention which version but I believe it was 249 NC indexes per table in 2005 and they went up to 999 NC indexes per table from 2008 up to 2012.

    http://msdn.microsoft.com/en-us/library/ms143432%28v=sql.110%29.aspx


    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

    Saturday, April 6, 2013 6:37 AM
  • Come across the below url with answers having reasons also..!!!!!!

    http://stackoverflow.com/questions/4245086/reason-for-the-count-of-non-clustered-index-in-sql-server


    Regards http:\\sqldbatask.blogspot.com MCTS Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    Monday, April 8, 2013 9:13 AM