GROUP BY might be distinctly better than DISTINCT
One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the
Tag: sql
Listener log data mining with SQL
If you take a look at the log files created by the listener, there is obviously a nice wealth of
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
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
Extending in-lists
A well known “limitation” of Oracle is that you can only have 1000 elements within an IN-LIST style expression in
With and without WITH_PLSQL within a WITH SQL statement
OK, let’s be honest right up front. The motivation for this post is solely to be able to roll out
Being generous to the optimizer
In a perfect world, the optimizer would reach out from the server room, say to us: “Hey, lets grab a
