topic Re: views in Application Development and Automation Discussions

views

Former Member — Fri, 27 Apr 2007 09:31:19 GMT

Will the views get effected when updating the database?

Re: views

Former Member — Fri, 27 Apr 2007 09:33:04 GMT

yes

Re: views

Former Member — Fri, 27 Apr 2007 09:33:08 GMT

hi,

View are improves perfromance in the following aspects

1. If you want to use more than two table in 'JOIN' condition better to use Views . It will improves performance of a program

2. If you want to use mutiple FOR ALL ENTRIES clause, better to club all SELECT statement in a view.

note:

1.Views does not contain data in it. It fetches data from the database only depending on the condition ...

2.Views are part of data dictionary. They are a window to view the data in database

3.views can be used to give security to data. users can be allowed to view only basic data only

Regards

Reshma

Re: views

Former Member — Fri, 27 Apr 2007 09:34:10 GMT

Hi,

yes, the view will also be updated automatically when we update the database.

reward points if useful.

regards

vivek

Re: views

Former Member — Fri, 27 Apr 2007 09:34:12 GMT

hi,

yes def vies by themselves dont have any data they hold the data from tables only oaccording to certain condotions so when u update tables it will affect the corresponding views also

reward if helpful

ravi

Re: views

Former Member — Fri, 27 Apr 2007 09:34:31 GMT

Hi,

Views will not be afftected when updating the database tables.

Views data will be fetched during runtime.

Reward if useful,

Thanks,

USR