how often the view get's updated

[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

[julian]

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?

[prodadmin]

It's a regular view

[patel_dil]

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?

[prodadmin]

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

[slimdave]

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.