Toad World

Blogs

Iggy Fernandez
Follow /1 Aug 2016 at 2:00am / Oracle Blog

An introduction to Oracle Database for beginners: What is a relational database management system?—Part V

A series of posts in response to Tim Ford’s #EntryLevel Challenge . “If we shadows have offended, Think but this, and all is mended, That you have but slumber’d here While these visions did appear. And this weak and idle theme, No...
1219 0 /
Iggy Fernandez
Follow /1 Aug 2016 at 2:00am / Oracle Blog

An introduction to Oracle Database for beginners: What is a relational database management system?—Part IV

A series of posts in response to Tim Ford’s #EntryLevel Challenge . Part I: Getting started with Oracle Database Part II: What is a Database? Part III: What is a Relational Database? Part IV: What is a Database Management System? ...
1063 0 /
Iggy Fernandez
Follow /1 Aug 2016 at 2:00am / Oracle Blog

An introduction to Oracle Database for beginners: What is a relational database management system?—Part III

A series of posts in response to Tim Ford’s #EntryLevel Challenge . Part I: Getting started with Oracle Database Part II: What is a Database? Part III: What is a Relational Database? Part IV: What is a Database Management System? ...
787 0 /
Iggy Fernandez
Follow /1 Aug 2016 at 2:00am / Oracle Blog

An introduction to Oracle Database for beginners: What is a relational database management system?—Part II

A series of posts in response to Tim Ford’s #EntryLevel Challenge . Part I: Getting started with Oracle Database Part II: What is a Database? Part III: What is a Relational Database? Part IV: What is a Database Management System?...
1180 0 /
Iggy Fernandez
Follow /1 Aug 2016 at 2:00am / Oracle Blog

An introduction to Oracle Database for beginners: What is a relational database management system?—Part I

A series of posts in response to Tim Ford’s #EntryLevel Challenge . “If we offend, it is with our good will. That you should think, we come not to offend, But with good will. To show our simple skill, That is the true beginning of our end...
1776 0 /
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...
1684 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”...
1944 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...
1279 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...
1278 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...
1312 0 /