View vs Table?
317288Dec 24 2003 — edited Jan 2 2004Hi,
My manager insist to create View in Database first, then all my JDBC call will hit the View instead of table. She said it will make my java program more independant from database change i.e. table structure, name changes etc...
My questions are:
1. if I use View, any impact on performance?
(there is only a few tables in Database with each table about 25000 records, one field is indexed)
2. I have a dbms_jobs to update a table once per day, can the View pick up the latest update in real time?
3. Can I update the view from JDBC? If so, does the update will be in table also?
Thanks.
David