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.