How to create materialized views in SQL Server?

by

They’re called indexed views in SQL Server – read these white papers for more background:

Basically, all you need to do is:

  • create a regular view
  • create a clustered index on that view

and you’re done!

The tricky part is: the view has to satisfy quite a number of constraints and limitations – those are outlined in the white paper. If you do this, that’s all there is. The view is being updated automatically, no maintenance needed.

Additional resources:

More Related Contents:

  1. How can you represent inheritance in a database?
  2. What are the best practices for using a GUID as a primary key, specifically regarding performance? [closed]
  3. Use float or decimal for accounting application dollar amount?
  4. When/Why to use Cascading in SQL Server?
  5. What columns generally make good indexes?
  6. What’s the longest possible worldwide phone number I should consider in SQL varchar(length) for phone
  7. SQL Server: the maximum number of rows in table [closed]
  8. SQL Unique constraint across multiple tables
  9. Best way to store time (hh:mm) in a database
  10. Database design: Calculating the Account Balance
  11. How to store directory / hierarchy / tree structure in the database?
  12. Date range overlapping check constraint
  13. “Prevent saving changes that require the table to be re-created” negative effects
  14. Unique identifier (guid) as primary key in database design
  15. How to choose the clustered index in SQL Server?
  16. How do I generate a random number for each row in a T-SQL select?
  17. Auto increment primary key in SQL Server Management Studio 2012
  18. SQL Server Linked Server Example Query
  19. Combine multiple results in a subquery into a single comma-separated value
  20. Infinite loop CTE with OPTION (maxrecursion 0)
  21. SQL Server: Attach incorrect version 661
  22. EF4 – The selected stored procedure returns no columns
  23. Get dates from a week number in T-SQL
  24. What are named pipes?
  25. How to update primary key
  26. Making an Entity Framework Model span multiple databases
  27. SQL Server 2008 Row Insert and Update timestamps
  28. SQL SERVER – Understanding how MIN(text) works
  29. How to convert text column to datetime in SQL
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment