Monthly Archives: January 2008

Nested Loop / Hash / Merge over Event 10053 trace file

January 31, 2008 – 7:06 pm

One of my colleague asked me about how he can write better SQL. Despite he is a java developer, I appreciate his will to understand database. When I said, “I really can not teach you this in ten minutes”, he lost his will. Any way, Lets talk about 10053 trace file. Oracle dumbs its execution [...]

By erturkdiriksoy | Posted in cost based optimizer | Tags: , , , , | Leave a Comment