NOEXPAND - naudojamas indeksuotuose viewuose, užtikrinti, kad vykdant užklausą bus lengvai prieinamos viewui reikalingos lentelės.
For the query optimizer to consider indexed views for matching or use an indexed view that is referenced with the NOEXPAND hint, the following SET options must be set to ON:
* ANSI_NULLS
* ANSI_PADDING
* ANSI_WARNINGS
* ARITHABORT
* CONCAT_NULL_YIELDS_NULL
* QUOTED_IDENTIFIERS
The NUMERIC_ROUNDABORT option must be set to OFF.
Komentarų nėra:
Rašyti komentarą