Mar 112013
 
select things_that_look_the_same_but
from   the_optimizers_point_of_view,
       are_different
where  we_clog_up_the_library_cache = 'Y'
and    cause_extra_hard_parses = 'Y';

SELECT things_that_look_the_same_but
FROM   the_optimizers_point_of_view,
       are_different
WHERE  we_clog_up_the_library_cache = 'Y'
AND    cause_extra_hard_parses = 'Y';

SELECT THINGS_THAT_LOOK_THE_SAME_BUT
FROM   THE_OPTIMIZERS_POINT_OF_VIEW,
       ARE_DIFFERENT
WHERE  WE_CLOG_UP_THE_LIBRARY_CACHE = 'Y'
AND    CAUSE_EXTRA_HARD_PARSES = 'Y';
A good argument for standardising SQL formatting is that different people writing the same SQL statement
will all write it the same way, reducing the chance of this issue occurring

For proof of this, use this script.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)