Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Impact of views on performances
I want to use views to isolate code from changes of my database schema; Yet
I am told that views will have a negative impact on performance with the
growing size of my database (today with the largest table at 150000 records,
but growing). Further, when I have index defined on the tables that I am
planning to access through views, will these indexes continue to be used?
Any idea of impact or where to look for in depth information?
Michel & Véronique Parisse Received on Wed Feb 09 2000 - 23:38:55 CST