Relational Databases

Using Oracle’s Partition Exchange Load for Very Large Target Tables

By | September 15th, 2015|Oracle|

The situation is very common in Data Integration where a good performing ETL load starts to slow down. The job that been running and loading data just fine, suddenly becomes too slow and becomes a bottleneck. There are many technical explanations for this to happen. Just to name a few, stale statistics, outdated hardware, software, [...]

Benefits and Limitations of Using Virtual Columns in Oracle Database

By | May 9th, 2015|Oracle|

As the name suggests, Oracle introduced the concept of defining columns on a table that will actually not store values. Instead, it is uses an expression based on other columns in the same table. A very interesting concept. Although these virtual columns appear as normal columns of the table when queried, they are actually not [...]

32 Tips for Oracle SQL Query Writing and Performance Tuning

By | May 8th, 2015|Oracle|

I am working with Oracle SQL from day when I joined IT industry and I have been fascinated by number of things I have learned about SQL, different databases and its usage over the years. In early phase of my career, I learned that writing SQL queries was not just about writing but writing so [...]

Learning About Exchange Partition Mechanism – Oracle

By | February 22nd, 2015|Oracle|

If you have been involved in creating and managing ETL (Extract, Transformation and Load) processes for datawarehousing environments, you know how time consuming it can be especially when data volume is high. One of the best features in Oracle data warehousing is the ability to swap-out standard Oracle tables and partitioned tables. If you are [...]