Toad World


Iggy Fernandez
Follow /1 Jul 2016 at 3:30am / Oracle Blog

Believe it or Not: Converting an Inner Join to an Outer Join to improve performance

The cost-based optimizer tries to merge views whenever possible but sometimes we ma y want to override this behavior; that is, we may want the optimizer to push predicates into the view instead of merging the view into the main query. For example, consider...
1541 0 /
Iggy Fernandez
Follow /30 Jun 2016 at 3:48pm / Oracle Blog

The Oracle Database professional I admire most

“He couldn't move a mountain nor pull down a big oak tree But my Daddy became a mighty big man with a simple philosophy Do what you do, do well, boy Do what you do, do well Give your love and all of your heart And do what you do, do well”...
1824 0 /
Iggy Fernandez
Follow /30 Jun 2016 at 3:34pm / Oracle Blog

Point to Ponder: The most important insight about Oracle Database upgrades?

Every version of the Oracle Database brings new optimizer features, and, with them, the potential for changed query performance. For example, Oracle Database 12 c brought a slew of new features collectively labeled “adaptive” features. While...
1190 0 /
Iggy Fernandez
Follow /30 Jun 2016 at 2:00pm / Oracle Blog

Happy Hinting: Undocumented PUSH_PRED hint variation

The PUSH_PRED hint instructs the optimizer to push a join predicate into a view. Here is an example. The cost-based optimizer chooses to push the second predicate “e.job_id = v.job_id” and use the EMP_JOB_IX index. Note that we used the NO_MERGE...
1164 0 /
Iggy Fernandez
Follow /1 Jun 2016 at 3:41am / Oracle Blog

Major and Minor keys in Oracle NoSQL Database

Oracle NoSQL Database uses Major and Minor key values to achieve user-controllable record co-location. Records are stored based on the hash of the major key, so all of the records with the same major key will be co-located on the same server. A JSON...
1224 0 /
Iggy Fernandez
Follow /1 Jun 2016 at 2:00am / Oracle Blog

Oracle Cloud v/s Amazon Cloud

A few years ago, I taught an online class in Oracle Database administration for the University of Washington. Every student was given their own virtual machine in the Amazon cloud for the duration of the class, courtesy of Amazon. It was ridiculously...
1337 0 /
Iggy Fernandez
Follow /31 May 2016 at 1:00am / Oracle Blog

NoSQL workshop at Oracle user group conference

Oracle NoSQL Database has been regularly featured at the conferences of the Northern California Oracle Users Group. But, at its most recent conference, the Northern California Oracle Users Group dared to play outside the Oracle sandbox with a whole day...
1557 0 /
Iggy Fernandez
Follow /18 May 2016 at 2:00pm / Oracle Blog

The best Oracle Database idea since 1992: Putting the C into ACID (We need your vote)

Oracle Corporation is asking for community feedback on the SQL-92 CREATE ASSERTION feature. If you would like them implemented in Oracle Database, please vote at (click on the up-arrow). Yuu need to log into your...
2231 0 /
Iggy Fernandez
Follow /1 May 2016 at 7:00am / Oracle Blog

When SQLT is not enough

When tuning a SQL query, I rely on a SQLT report because it has all kinds of pertinent information including—to name just a few—optimizer settings, indexes, statistics, plan history, and view definitions. However, recently I came across a...
2172 0 /
Iggy Fernandez
Follow /30 Apr 2016 at 4:00am / Oracle Blog

How is data modeled in NoSQL?

The first question that you will have when you start your NoSQL journey is “How is data modeled in NoSQL?” The important thing to understand is the data does not change just because it is managed differently. If the data does not change, then...
1602 0 /