Re: Performance of Views
Scott Sosna wrote:
> With most databases, my experience has been that views perform like the underlying query because
> the query parser is just inserting the SQL of the view (especially when you just selecting from the
> view). However, that doesn't seem to be the case here.
I had similar experiences when I converted some of my queries to views.
Each time the view resulted in an EXPLAIN plan that needed to examine many more rows than the underlying query.
Maybe you should report this as a bug.
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Views
Written By
Posted
3105
August 15, 2005 05:44PM
1710
August 16, 2005 03:11AM
1617
August 16, 2005 04:32PM
Re: Performance of Views
1733
August 18, 2005 05:26AM
1766
August 18, 2005 08:12PM
1738
August 19, 2005 03:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.