All Forums Database
teradatatester 69 posts Joined 01/10
24 Jul 2012
Is it possible to refresh a view every 15 minutes using a trigger?

Is it possible to refresh a view every 15 minutes using a trigger?

 

Does anyone have an example of how you can refresh a view every so many minutes via a trigger?

VandeBergB 182 posts Joined 09/06
24 Jul 2012

The beauty of views is that you don't have to refresh them.  New or changed data in the base table is reflected in the view without any additional action on the database's part.

Some drink from the fountain of knowledge, others just gargle.

teradatatester 69 posts Joined 01/10
24 Jul 2012

Thanks!

You must sign in to leave a comment.