Blogs

Iggy Fernandez
Follow /28 Sep 2014 at 4:30pm / Oracle

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

Previous installment: The Final Exam! (Part III We Don’t Use Databases; We Don’t Use Indexes) First installment: DON’T PANIC Before continuing with this series, please take a minute to read any installments that you may have missed...
88 0 /
Iggy Fernandez
Follow /27 Sep 2014 at 5:30pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 22: The Final Exam! (Part III We Don’t Use Databases; We Don’t Use Indexes)

“Books to the ceiling, Books to the sky, My pile of books is a mile high. How I love them! How I need them I'll have a long beard by the time I read them” — Whiskers and Rhymes by Arnold Lobel Previous installment: The Final...
195 0 /
Iggy Fernandez
Follow /26 Sep 2014 at 5:30pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 21: The Final Exam! (Part II)

“Books to the ceiling, Books to the sky, My pile of books is a mile high. How I love them! How I need them I'll have a long beard by the time I read them” — Whiskers and Rhymes by Arnold Lobel Previous installment: The Final...
145 0 /
Iggy Fernandez
Follow /26 Sep 2014 at 5:30pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 20: The Final Exam! (Part I)

“Books to the ceiling, Books to the sky, My pile of books is a mile high. How I love them! How I need them I'll have a long beard by the time I read them” — Whiskers and Rhymes by Arnold Lobel Previous installment: Practice...
337 0 /
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 Next installment: The Final Exam! (Part I) 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...
549 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...
407 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...
354 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...
618 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...
421 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...
367 0 /