IndexingBehavior Enum

Definition

Controls how the AnalysisServices engine builds and persists indexes.

public enum IndexingBehavior
type IndexingBehavior = 
Public Enum IndexingBehavior
Inheritance
IndexingBehavior

Fields

Name Value Description
Off 0

Indexing is disabled. The semantic model will not perform indexing during refresh operations.

Auto 1

The semantic model might build in-memory index during data load or query execution.

Explicit 2

The semantic model will build and persist the index only when explicitly requested via a refresh indexes operation. Refresh types other than refresh indexes do not perform indexing.

Full 3

The semantic model builds and persists indexes as part of refresh full, refresh calculate and refresh indexes operations.

Remarks

This enum is only supported when the compatibility level of the database is at 1706 or above.

Applies to