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
2854
August 15, 2005 05:44PM
1571
August 16, 2005 03:11AM
1483
August 16, 2005 04:32PM
Re: Performance of Views
1602
August 18, 2005 05:26AM
1571
August 18, 2005 08:12PM
1620
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.