Timeline for Creating Non-Clustered Index on Non-Persisted Computed Column SQL Server
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 8, 2017 at 6:12 | history | tweeted | twitter.com/StackDBAs/status/829211186621214720 | ||
| Feb 7, 2017 at 21:30 | vote | accept | Uberzen1 | ||
| Feb 7, 2017 at 21:29 | answer | added | ypercubeᵀᴹ | timeline score: 8 | |
| Feb 7, 2017 at 21:29 | answer | added | Aaron Bertrand | timeline score: 8 | |
| Feb 7, 2017 at 21:28 | history | edited | Uberzen1 | CC BY-SA 3.0 |
added pasteThePlan
|
| Feb 7, 2017 at 21:09 | comment | added | Kin Shah | Non persisted Computed columns are not physically stored in the table. They are virtual columns. Their values are recalculated every time they are referenced in a query. see this ref. | |
| Feb 7, 2017 at 21:09 | comment | added | Aaron Bertrand | It is not persisted in the data pages of the table, but it is persisted in the pages of the index. | |
| Feb 7, 2017 at 21:08 | answer | added | Brent Ozar | timeline score: 11 | |
| Feb 7, 2017 at 21:05 | history | asked | Uberzen1 | CC BY-SA 3.0 |