Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Indexed View

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.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint