views

[Former Member]

Will the views get effected when updating the database?

[Former Member]

Will the views get effected when updating the database?

[Former Member]

yes

[Former Member]

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

[Former Member]

Hi,

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

reward points if useful.

regards

vivek

[Former Member]

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

[Former Member]

Hi,

Views will not be afftected when updating the database tables.

Views data will be fetched during runtime.

Reward if useful,

Thanks,

USR