how often the view get's updated

Hi ,

I created a view based on three tables.I would like to know how often the view gets updated.

The based tables will get updated every 2 to 5minutes.Will it get updated if We have new data in any table

Can some one explain me

thanks

Quote:

---

Originally posted by prodadmin
Hi ,

I created a view based on three tables.I would like to know how often the view gets updated.

The based tables will get updated every 2 to 5minutes.Will it get updated if We have new data in any table

Can some one explain me

thanks

---

What view? A materialized view?

It's a regular view

Regular view does not take any time. It is as good as you are fetching data from base tables. So it should be instantaneous. what made you think it takes 2-3 minutes? any test/observation?

Thank you Dilip!!
I was just guessing "will there be any delay?"
I know materiliazed views updates depend upon the time we specify.

Read the concepts manual, 'cos ithink you don't understand what a view is. It's just a query hidden inside a logical wrapper -- you selct from the view, the query get's executed.