Blog Aggregator - Amardeep Sidhu

  • Tags

  • Archives

  • Meta

  •  

    February 2008
    M T W T F S S
    « Jan   Mar »
     123
    45678910
    11121314151617
    18192021222324
    2526272829  

Archive for February 18th, 2008

Posted in Oracle, SQL, contest, oraclecommunity by: Eddie Awad
Comments Off

18 Feb

Oracle Community Contest: Obfuscated SQL Code

Do you think there is a point in arranging an Obfuscated SQL Contest, modeled after the infamous Obfuscated C Contest? Chen Shapira asked. I replied: Great idea! So, welcome to the first ever Oracle Community contest.

To learn more, or to participate, proceed to this page on OracleCommunity.net.
—Related Articles at Eddie Awad’s Blog:New Oracle ACE and […]

Posted in CBO, Execution plans, Hints by: Jonathan Lewis
Comments Off

18 Feb

Pushing Predicates

Some time ago I wrote a note (on my website) about the push_pred() and no_push_pred() hints. I’ve recently discovered a bug in the 9.2 optimizer that means you may find that Oracle will not use “join predicate pushing” when it is obviously a good idea.
This note discusses a sequence of execution plans, taken from a […]

© 2008 Blog Aggregator - Amardeep Sidhu | Entries (RSS) and Comments (RSS)

Powered by Wordpress, design by Web4 Sudoku, based on Pinkline by GPS Gazette