Changes for page SQL Server Index Design

Last modified by Billie D on 2021/02/12 18:04

From version 23.1

edited by Billie D
on 2021/02/12 20:55

To version 24.1

edited by Billie D
on 2021/02/12 18:04

Change comment: There is no comment for this version

Summary

Page properties

Content

@@ -188,7
          +188,7 @@
  = Index Views =
  A database view in SQL Server is __like a **virtual table**__ that represents the output of a SELECT statement.  __In general it doesn’t stored any data__ ~-~- every time a view is queried, it further queries the underlying tables by executing its associated SELECT statement.
--\\A database view can be **__materialized__** on the disk by __creating a **unique clustered index** on the view__, referred to as **index view** or **materialized view**, __**persisted in physical storage** in the database__, saving overhead of performing costly operations during query execution.  After the view is materialized, multiple clustered indexes can be created on the indexed view.
++\\A database view can be **__materialized__** on the disk by __creating a **unique clustered index** on the view__, referred to as **index view** or **materialized view**, __**persisted in physical storage** in the database__, saving overhead of performing costly operations during query execution.  After the view is materialized, multiple NON clustered indexes can be created on the indexed view.
  Benefit: