All geek questions in one place

Please explain the SET parameter requirements for calculated columns.

Creating indexes in calculated columns contains a list of six SET parameters that should be included, and one that should be turned off when using calculated columns in the index.

Why should they be installed this way?

+3
source share
2 answers

Because you do not want the computed columns to be more expensive than possible, and you would prefer to have one, tightly written and verified code path responsible for them, or 128 different codes (2 ^ 7 combinations of options).

They allow the developers of this code to simply assume that it is.

+1
source

Hm, , , SQL Server ?: -)

, . SET , , , .

0

Source: https://habr.com/ru/post/1731998/

More articles:


All Articles