Blogs

Iggy Fernandez
Follow /29 Oct 2014 at 5:00pm / Oracle

OT: Oracle Trivia Quiz

All the answers to the quiz are in the November 2014 issue of the NoCOUG Journal . I am the editor of the NoCOUG Journal. What’s NoCOUG, you ask? Only the oldest and most active Oracle users group in the world. If you live in the San...
78 0 /
Iggy Fernandez
Follow /29 Oct 2014 at 3:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 26: Answers to the Final Exam! (Part IV)

Previous installment: Answers to the Final Exam! (Part III) First installment: DON’T PANIC Here are the answers to the problem in Part 22 of this series “ We Don’t Use Databases; We Don’t Use Indexes .” External tables...
112 0 /
Iggy Fernandez
Follow /28 Oct 2014 at 12:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 25: Answers to the Final Exam! (Part III)

Previous installment: Answers to the Final Exam! (Part II) Next installment: Answers to the Final Exam! (Part IV) First installment: DON’T PANIC Here are the answers to the third problem in Part 21 of this series. Here is the SQL query and it’s...
139 0 /
Iggy Fernandez
Follow /26 Oct 2014 at 4:30pm / Oracle

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

Previous installment: Answers to the Final Exam! (Part I) Next installment: Answers to the Final Exam! (Part III) First installment: DON’T PANIC Here are the answers to the second problem in Part 21 of this series. Here is the SQL query and its...
133 0 /
Iggy Fernandez
Follow /26 Oct 2014 at 12:00am / Oracle

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

Previous installment: The story so far (Part 11–22) Next installment: Answers to the Final Exam! (Part II) First installment: DON’T PANIC Here are the answers to the first problem based on the following query and execution plan in Part...
153 0 /
Iggy Fernandez
Follow /28 Sep 2014 at 5: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) Next installment: Answers to the Final Exam! (Part I) First installment: DON’T PANIC Before continuing with this series, please take a minute...
191 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...
349 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...
245 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...
474 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...
629 0 /