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: