Blogs

Iggy Fernandez
Follow /30 Aug 2014 at 3:53am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 19: Practice Exam IV

Previous installment: Practice Exam III First installment: DON’T PANIC The translation of a SQL statement into an efficient sequence of relational algebra operations is a tremendously complex task. The goal is to find the most efficient sequence...
445 0 /
Iggy Fernandez
Follow /28 Aug 2014 at 5:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 18: Practice Exam III

Previous installment: Practice Exam II Next installment: Practice Exam IV First installment: DON’T PANIC Every time the optimizer chooses to join two data sets using the hash-join method, it has to decide which of the two data sets will be the...
322 0 /
Iggy Fernandez
Follow /27 Aug 2014 at 5:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 17: Practice Exam II

Previous installment: Practice Exam I Next installment: Practice Exam III First installment: DON’T PANIC Here is the second practice exam. This time, we use the following hints in the query. Instead of the USE_NL hints that you saw in the previous...
250 0 /
Iggy Fernandez
Follow /26 Aug 2014 at 5:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 16: Practice Exam I

Previous installment: Oracle-in-the-box Next installment: Practice Exam II First installment: DON’T PANIC To prepare for the final exam, let’s do some practice exams. To do the exams, you will need your own Oracle Developer Day VM ( Oracle...
508 0 /
Iggy Fernandez
Follow /25 Aug 2014 at 5:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 15: Oracle-in-the-box

Previous installment: Damn the Cost, Full Speed Ahead Next installment: Practice Exam I First installment: DON’T PANIC I use the HR sample schema in all my demonstrations. It is one of the sample schemas used in the examples found in the Oracle...
323 0 /
Iggy Fernandez
Follow /29 Jul 2014 at 3:57pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 14: Damn the Cost, Full Speed Ahead

“Money is our madness, our vast collective madness. And of course, if the multitude is mad the individual carries his own grain of insanity around with him. I doubt if any man living hands out a pound note without a pang; and a real tremor, if he...
309 0 /
Iggy Fernandez
Follow /27 Jul 2014 at 9:53am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 13: The Great Pretender

Oh-oh, yes I'm the great pretender Pretending that I'm doing well My need is such, I pretend too much I'm lonely but no one can tell Yes, I'm the great pretender Just laughin' and gay like a clown I seem to be what I'm not, you...
455 2 /
Iggy Fernandez
Follow /24 Jul 2014 at 12:39am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 12: Throw Away that Execution Plan

Here's a little song I wrote You might want to sing it note for note: Don't worry, be happy. In every life we have some trouble; When you worry you make it double. Don't worry, be happy. —Don’t Worry Be Happy by Bobby McFerrin...
541 0 /
Iggy Fernandez
Follow /22 Jul 2014 at 4:08pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 11: Abandon All Hope

“Through me the way among the people lost. All hope abandon, ye who enter in!” — Inscription on the gate of Hell from Divine Comedy by Dante Alighieri (14 th century) Previous installment: The story so far Next installment: Throw...
336 0 /
Iggy Fernandez
Follow /29 Jun 2014 at 2:39pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN: The story so far (Part 1–10)

Previous installment: Mystery Tree First installment: DON’T PANIC Before continuing with this series, please take a minute to read any installments that you may have missed. Part 1—DON’T PANIC : Even experienced application developers...
499 0 /