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).
.
.
.
(See Tom Kyte's explanation of how the two queries actual perform differently).
.
.
.
No comments:
Post a Comment