![]() ![]() In the developer and enterprise editions of SQL Server, the optimizer can use the indexes of views to optimize queries that do not specify the indexed view. Queries that don’t specifically use the indexed view can even benefit from the existence of the clustered index from the view. ![]() The clustered index is stored in SQL Server and updated like any other clustered index, providing SQL Server with another place to look to potentially optimize a query utilizing the indexed view. What’s an Indexed View?Īn indexed view has a unique clustered index. Data isn’t stored in the database and the result set is determined while the view is executed. Views are a virtual table defining a query against one or more tables.
0 Comments
Leave a Reply. |