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

  • Question

  • Hi,

    How many non cluster index available in a table?



    Saturday, April 6, 2013 5:13 AM


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.


    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..!!!!!!


    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