Top "Indexed-view" questions

Is it possible to have an indexed view in MySQL?

I found a posting on the MySQL forums from 2005, but nothing more recent than that. Based on that, it's not …

Read More
sql mysql views materialized-views indexed-view
How do indexes work on views?

Can someone please explain to me in simple English how an index on a view works? I have a fairly …

Read More
sql sql-server indexing views indexed-view
SQL Server - Creating a Schema Bound Indexed View with a current GetDate filter

I want to create the following indexed view: CREATE VIEW [Cic].[vwMarker] WITH SCHEMABINDING AS Select SubId, marker.EquipmentID, marker.…

Read More
sql-server sql-server-2008 indexed-view
How do you list all the indexed views in SQL Server?

How can you get a list of the views in a SQL server database that have indexes (i.e. indexed …

Read More
sql-server tsql sql-server-2008 metadata indexed-view
SQL Server Create View Index which contains distinct or group by

I have a table of address data in my SQL server database. This table is not normalized so it contain …

Read More
sql-server sql-server-2008 indexed-view
How can i speed up this Indexed View?

I have a simple Indexed View. When I query against it, it's pretty slow. First I show you the schema's …

Read More
sql sql-server tsql sql-server-2008 indexed-view
How do I check the size of an indexed view in SQL Server?

Its easy to check storage sizes for Tables and Indexes, you can right-click the table object on SSMS explorer and …

Read More
sql-server ssms indexed-view system-stored-procedures