Want to save Processor Time and Increase Response performance SQL 2003

Hi Pals,

SQL 2003
Database: 1000 Tables

As I understand from the theory "Views" are nothing but the queries stored in the databse. Whenever the views are being refered then only it starts calculation (process of querying).Thus it consumes processor time for each View reference and simultaniously it Takes some time to respond.

To avoid the above situation I am planning to add all the views as precomputed tables in the database.

What impact will come on performance? Am I going to right direction ?

You all are invited for the suggestions and discussions.



Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!