Blogs

Iggy Fernandez
Follow /2 Mar 2015 at 5:10am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 36: The sisters of the mother of all SQL antipatterns

SECOND WITCH. Fillet of a fenny snake, In the caldron boil and bake; Eye of newt, and toe of frog, Wool of bat, and tongue of dog, Adder's fork, and blind-worm's sting, Lizard's leg, and owlet's wing,— For a charm of powerful trouble...
727 0 /
Iggy Fernandez
Follow /7 Feb 2015 at 8:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 35: Robust v/s optimal query execution plans

Previous installment: SQL Aaargh! Next installment: The sisters of the mother of all SQL antipatterns First installment: DON’T PANIC In a prior post The Mother of All SQL Antipatterns , I suggested that the best solution for the ad-hoc query...
1204 0 /
Iggy Fernandez
Follow /7 Feb 2015 at 7:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 34: SQL Aaargh!

Previous installment: The mother of all SQL antipatterns? Next installment: Robust v/s optimal query execution plans First installment: DON’T PANIC The biggest problem with SQL query optimization is that semantically equivalent SQL queries are...
1050 0 /
Iggy Fernandez
Follow /5 Feb 2015 at 9:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 33: The mother of all SQL antipatterns?

“Beware the Jabberwock, my son! The jaws that bite, the claws that catch! Beware the Jubjub bird, and shun The frumious Bandersnatch!” —from Through the Looking-Glass and What Alice Found There by Lewis Carroll Previous installment...
1391 0 /
Iggy Fernandez
Follow /28 Jan 2015 at 9:00pm / Oracle

OT: Pictures from the NoCOUG winter conference at Oracle HQ

There were 130 attendees at the NoCOUG winter conference on January 27 at the Oracle conference center in Redwood City. There was a fantastic breakfast spread. The registration desk was a marvel of neatness. Delphix sent its most photogenic...
530 0 /
Iggy Fernandez
Follow /27 Jan 2015 at 2:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 32: Pretzels created by someone experimenting with hallucinogens?

Previous installment: How to Avoid a Salted Banana Next installment: The mother of all SQL antipatterns? First installment: DON’T PANIC In an interview for the NoCOUG Journal , Steven Feuerstein was asked: “SQL is a set-oriented non-procedural...
1325 0 /
Iggy Fernandez
Follow /26 Jan 2015 at 1:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 31: How to Avoid a Salted Banana

Previous installment: Throw Away That EXPLAIN PLAN! (Part IV) Next installment: Pretzels created by someone experimenting with hallucinogens? First installment: DON’T PANIC In the February 2015 issue of the NoCOUG Journal , Lothar Flatz introduces...
1030 0 /
Iggy Fernandez
Follow /3 Jan 2015 at 6:00pm / Oracle

OT: Win a free NoCOUG membership for yourself and three friends

You can win a free membership in the Northern California Oracle Users Group (NoCOUG) for yourself and three friends by correctly identifying the colorful objects on the front cover of the winter issue of the NoCOUG Journal and where the picture was taken...
349 0 /
Iggy Fernandez
Follow /31 Dec 2014 at 5:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 30: Throw Away That EXPLAIN PLAN! (Part IV)

Previous installment: Throw Away That EXPLAIN PLAN! (Part III) Next installment: How to Avoid a Salted Banana First installment: DON’T PANIC The execution plans in the last post were interesting—especially the one in which the child table...
583 0 /
Iggy Fernandez
Follow /30 Dec 2014 at 12:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 29: Throw Away That EXPLAIN PLAN! (Part III)

Previous installment: Throw Away That EXPLAIN PLAN! (Part II) Next installment: Throw Away That EXPLAIN PLAN! (Part IV) First installment: DON’T PANIC As I said, the second query is a performance hog beause it deletes all orphans created by the...
487 0 /