Indexing A Numeric Computed Column

Question

Indexing A Numeric Computed Column

Steve Jones - SSC Editor

SSC Guru

Points: 738227
More actions
October 8, 2019 at 12:00 am

#3679569

Comments posted to this topic are about the item Indexing A Numeric Computed Column

Viewing 5 posts - 1 through 5 (of 5 total)

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

Stewart "Arturius" Campbell SSC Guru Points: 72727 More actions · Answer 1

Nice question, thanks Steve. i like the red herrings....

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Sean Lange SSC Guru Points: 286602 More actions · Answer 2

Good question. I am curious though why would somebody think this wouldn't work.

This reply was modified 5 years, 8 months ago by Sean Lange.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Steve Jones - SSC Editor SSC Guru Points: 738227 More actions · Answer 3

I've run into people that were sure you couldn't index unless this was persisted.

Stewart "Arturius" Campbell SSC Guru Points: 72727 More actions · Answer 4

Steve Jones - SSC Editor wrote:

I've run into people that were sure you couldn't index unless this was persisted.

used to work with one - he would always reject code reviews where were indexes created on computed columns unless said column was persisted....

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Indexing A Numeric Computed Column

Cookies on SQLServerCentral