Boots Performance -- sql server data warehouse

Travis
9/18/2005 8:34:03 PM

Hi ,

I already create clustered and non clustered index in order to improve the
reports performance. But after I test several times on my reports , the
processing time almost the same as before I index the table.
Any other method to increase the performance ? Can I index the "view" I
created ?

--

Danny
9/19/2005 11:56:34 AM

Travis,

The group will need substantially more information in order to help diagnose
your performance issue. The basic answers to your questions are Yes. and
most likely yes depending on the version you are running.

Please post more information including:
SQL Server version
Basic hardware configuration
The query
The estimated query plan
What is the database used for (OLTP, DSS, Reporting, etc.)

[quoted text, click to view]

sql server data warehouse : Boots Performance