Helmut
When you tune views you have to keep in mind how you select from the view - you
may tune perfectly the select statement that builds the view but when you select
from the view the query may be very slow. When you run select * from myview
the performance may be much different than select
Helmut,
Oracle *can* push the criteria down into the view definition in many
situations. Certain operations, though, will not allow this to happen. You
can find some info on Metalink, and, in the Oracle 8i Designing and Tuning
for Performance manual. There are other source as well. Here is a