Howdy, Stranger!

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

Categories

Want to save Processor Time and Increase Response performance SQL 2003

ShishyaShishya Member Posts: 11
Hi Pals,

Scenario:
SQL 2003
Database: 1000 Tables
2000 Views


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.

Thanks

Shishya

Sign In or Register to comment.