indexed view

The view (and its accompanying index, if it is an indexed view) can be copied to the Subscriber, but the base table must also be replicated.

Creates a histogram and associated density groups (collections) over the supplied column or set of columns of a table or indexed view.

Like an index in a book, an index in a database lets you quickly find specific information in a table or indexed view.

A query can use an indexed view in its execution plan even if it does not satisfy these GROUP BY restrictions.

Added to the list of requirements for a view that direct references to Xquery expressions are not allowed in an indexed view definition.

A view with a unique clustered index is called an indexed view.

Transactional replication allows you to replicate an indexed view as a view or as a table.

Is the name of the target table or indexed view for which statistics should be dropped.

For an indexed view, drop the view, and then redefine it by using an explicit CONVERT function with a deterministic date style.

If the query optimizer decides to use an indexed view in a query plan, the indexed view is treated the same way as a base table.

Because you intend this to be an indexed view, be sure to add only tables that you own.

No other imprecise expressions can be part of the key column of an indexed view .

Can be the object identifier of a procedure, view, indexed, view, or UDF.

A database containing an indexed view cannot be changed to a compatibility level lower than 80.

This may be caused by the optimizer choosing not to access the table at all, or because an indexed view is accessed instead .

In particular, the query optimizer is less likely to match the query to an indexed view or an index on a computed column.

Is the name or ID of the table or indexed view for which to report and correct space usage statistics.

Of every table and indexed view in the filegroup.

API cursor query contains an indexed view with a unique access path, but not at the base-table level.

The definition of an indexed view must be deterministic.

The configuration should not specify adding an already-existing index or indexed view to the database.

CREATE STATISTICS can be executed on an indexed view.

For every partition used by a table (heap or clustered table), index, or indexed view, there is one ROW_OVERFLOW_DATA allocation unit.

The rows of an indexed view are stored in the database in the same format as a table.

Is not specified, all distribution statistics in the specified table or indexed view are updated.

Is the name of the table or indexed view for which to update statistics.

The indexed view or computed column cannot be created.

Otherwise, statistics are derived from the underlying tables before the indexed view is substituted into the query plan.

An INSERT, UPDATE, or DELETE operation modifies data values stored in the indexed view or indexed computed column.

Checks the integrity of all the pages and structures that make up the table or indexed view.

In general, you can request notification for any query that can be used to create an indexed view.

Nonclustered indexes on an indexed view are aligned with the indexed view.

Indexed view definitions can also now contain scalar aggregate and user-defined functions with certain restrictions.

The default behavior is to perform a sample scan on the target table or indexed view.

You must make sure that the new view meets all the requirements of an indexed view.

To force the optimizer to use an index for an indexed view, specify the NOEXPAND option.

The order in which numbers are added during indexed view maintenance can sometimes have a generally small effect on the final result.

Is the object identification number of the table or indexed view.

These GROUP BY restrictions are applicable only to the indexed view definition.

An indexed view has the same storage structure as an indexed table.

The operation you are performing will automatically remove schema binding from an indexed view.

Participate in an indexed view.

Is the name of the table or indexed view.

An indexed view is a view whose result set is stored in the database for fast access.

Does the indexed view compute a SUM aggregate over values of type float or real?

Object ID of the table or indexed view that the partition is part of.

Log-based indexed view article with manual filter and manual view.

There is any insert, update, or delete operation performed on any table that participates in the indexed view.

Is the table or indexed view for which to run integrity checks.

Only one full-text index is allowed per table or indexed view.

You can create multiple nonclustered indexes on a table or indexed view.

View and indexed view articles are not supported.

Log-based indexed view article with manual view.

Two queries are included that use the indexed view.

Indexed view logbased Log-based indexed view article.

Indexed view with schema only.

The indexed view is used by the query optimizer to produce the query plan.

To create an indexed view, a unique clustered index is defined on one or more view columns.

For example, the following script shows how to compare an indexed view and a computed view that differ slightly.

For example, an indexed view SELECT list cannot contain the expression AVG(column1).

If the differences between your indexed view and computed view are anything other than small differences in a SUM aggregate of a

Changes to Indexed View Article of a Transactional Publication Are Not Saved

Suboptimal Performance Using a Cursor to Update a Heap Involved in an Indexed View

Suboptimal Execution Plan on an Indirect UPDATE to an Indexed View

ALTER INDEX REBUILD Disabled clustered index or disabled indexed view

Nonclustered index on an indexed view