Post reply

Create Index on computed column

  • January 9, 2008 at 10:17 am

    #182659

    I just had an interview. The guy said he created a non-cluster index on a computed column, I usually created the index on the columns that used in creating the computed column.

    I don't know how he could create a index on a computed column since it was based on other columns.

  • January 9, 2008 at 10:29 am

    #766319

    You can create an index on computed columns with certain connection settings. The index will store the computed values on disk.

    Check "Creating Indexes on Computed Columns" in the books online

  • January 9, 2008 at 11:31 am

    #766343

    You have to mark the calculated column as persisted (the results must also be deterministic).

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply