View Single Post

   
  #1 (permalink)  
Old 03-04-2008, 06:23 AM
Gordowey
 
Posts: n/a
Default Views & performance

Hi, simple question

I have 2 hugge tables Table A and Table B. I define a view over these
2 tables (select,..joint,...)

My question is:
Does the DB2 runs the query every time that I access the View? or only
the first time that I create the view.

Is the answer is Yes,...then: Can I set to refresh the view only 1 a
day?

I am asking this, because both tables are really big (about
100.000.000 rows),..and I suppose that running the query to refresh
the view everytime I access it,...will slow down everything,....

thanks, Al
Reply With Quote