Indexed View

Example: Users frequently use a view, and you are tasked with optimizing its use. You can create an index on the view and make it an indexed view. Use to optimize frequently used views.

• The indexed view must contain a clustered index.

• To create an indexed view, several requirements exist. They are

  • The view must be created using WITH SCHEMABINDING.

  • The view can only reference tables, not other views.

  • The view must be deterministic. In other words, the view cannot contain any nondeterministic functions.

  • Tables must be referenced by two-part names.

  • Included functions must be referenced by two-part names.

• Database Tuning Advisor can be used to identify best views to create indexes on based on workload. This includes keeping or dropping existing indexed views.