Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hugo Kornelis Index types 2 RE: Index types 2

  • August 30, 2012 at 1:22 am

    #1531736

    Thanks, Koen! (EDIT: And Braindonor, who added a reply while I was typing)

    I submitted this question quite a long time ago - and I found that I had to spend time to research some of the options again. :w00t:

    BTW, maybe it's a bit early to say anything about the percentages, but at this point I am mainly surprised at:

    * 28% wrong answers on the "bitmap on computed" option - I expected this to be lower

    * 17% wrong answers on the "nonclustered on a view" option - here, I expected a higher failure rate

    The other percentages are (so far) about on par with my expectation.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/