Exadata storage indexes
We had a question on AskTOM inquiring about how to handle the issue of only 8 storage indexes being possible
Do you work in I.T?
If you do, then you know that only 20% of your I.T work is spent at the office. And no,
Cloning a schema with one line
In the world of DevOps, continuous integration and repeatable test cases, the demand for being able to quickly build a
DML error logging redux
I posted a nice little feature of DML error logging recently, and a comment came in mentioned that caution is
The holistic SQL tuning series
I did a set of articles for Oracle Magazine on a more holistic view of SQL tuning. What do I
The definition of proof
One of the pieces of advice that I often see on the ‘net is that undo space is somehow this
A refreshing look at PIVOT
We had an AskTOM question come in recently where our customer was very excited about the PIVOT operator in SQL
