Search My Oracle Blog

Custom Search

06 March, 2012

Another example of COST in an Explain Plan

Jonathan Lewis has identified a seemingly simple example of a COUNT(*) query that can be written in two manners, has the same COST in an Explain Plan (although the Plan is different) and yet has very different actual performance characteristics.
(See Tom Kyte's explanation of how the two queries actual perform differently).
.
.
.

No comments:

Aggregated by orafaq.com

Aggregated by orafaq.com
This blog is being aggregated by orafaq.com

Top 50 Oracle SQL Blogs 2016

Top 50 Oracle SQL Blogs 2016
Top 50 Oracle SQL Blogs 2016