Home Forums Article Discussions Article Discussions by Author Discuss content posted by Manie Verster Creating indexes on computed columns RE: Creating indexes on computed columns

  • September 30, 2010 at 2:22 am

    #1229489

    UMG Developer (9/29/2010)

    I think you need to check the answer key for this question. It lists "Column references can pull data from multiple rows." as one of the options you have to pick, but then in your explanation you say "No column reference pulls data from multiple rows."

    And the BOL article you link to says 'No column reference pulls data from multiple rows.", so it seems that "Column references can pull data from multiple rows." is not a correct choice. Either that or you meant for the can to be can't.

    Fully agree with UMG Developer.

    And I'd also agree with Chris Büttner--but in order to gain a point, just stick with the wording in BOL and disregard anything else, as computed columns need to be persisted in order to be used in an index (and the question was only about 'computed columns' but not about 'persisted computed columns'). 😎

    Regards,

    Michael