We are about to start a new project that includes fairly large data sets. Additionally, in many cases we have to grab data from a variety of tables.
I was looking over SQL Server 2005 Indexed Views and I am currently considering using them to boost the performance of the joined tables I need to query and display results.
Does anyone have experience in using Indexed Views as a means of increasing the performance of large table joins
Additionally, the documentation I read up on the Indexed views seemed a little vague regarding which versions they work with. Does SQL Server 2005 Standard Edition support Indexed Views or is it available only in Enterprise
Thanks in advance,
Chad
Indexed Views
Hot Topic
- Data Access Differences in SQL Server 2005
- Is there a way to build an SSIS project in script?
- Column Row Delimeter Problem
- Combining text data rows
- dbnull
- [OLE DB] how can i use IRowChange::Insert() to insert data ?
- SQL Express, Windows XP Pro, & concurrent users
- 2 notification classes in the one app.xml
- identity_insert in SQL 2005
- What version to use?
SQL Server
- Is SSIS slower than DTS????!!!!!!
- Problem with text field: text input too long, weird characters
- what hte use of SQL Native Client??
- Problem with text field: text input too long, weird characters
- Report Subscription sends wrong version
- How can i generate a cube of XML Data
- Network access to Sql Server 2005 Express
- problems in creating report (parent child hierarchy)
- Error Message "Key Sequence columns are not supported at the case level"
- Deploy with assembly error
Indexed Views
Michael Lipp MSFT
Indexed views can be created in any edition of SQL Server 2005. In SQL Server 2005 Enterprise Edition, the query optimizer automatically considers the indexed view. To use an indexed view in all other editions, the NOEXPAND view hint must be used.
http://whidbey.msdn.microsoft.com/library/en-us/udb9/html/669b47d9-ab28-4656-ab68-1ed6f69f54c2.asp