Boots Performance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Travis - 19 Sep 2005 04:34 GMT

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 ?

Signature

Travis Tan

Reply to this Message

Danny - 19 Sep 2005 12:56 GMT

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.)

> Hi ,
>
[quoted text clipped - 4 lines]
> Any other method to increase the performance ? Can I index the "view" I
> created ?

Reply to this Message