• michael.kaufmann (1/18/2011)


    Thanks for the question--got it wrong as I missed the indexes on computed columns will not be used.

    However, I'm baffled about the statistics, as only 25 % of the responders apparently ticked this option, but there are 73 % of correct answers. That's either higher mathematics (I don't have a grasp on) or the statistics did not get updated.

    Michael, the reason for this is in the message right above yours. Steve awarded points back to people who had already replid. That means that at that moment, the percentage of correct answer went up to 100%, but the distribution of selected answers remained unchanged.


    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/