Why indexes are so fast at finding a key
Glance through any text book, blog post, video tutorial etc on the topic of database indexes and you’ll typically chance
Blazingly fast documentation search with APEX
The Oracle documentation set is my bread and butter for day to day work. With AskTom questions, StackOverflow question, Einstein
APEX_DATA_PARSER turbo boost!
One of the most common recommendations I’ll make to customers who post questions on AskTom is “Install APEX even if
SQL*Net and the CONTAINERS clause
Complete separation of pluggable databases is naturally a good thing when it comes to protecting the rights and data of
The performance report you are NOT using
Just a quick post today to inspire you to look further than the standard options for performance monitoring. Quiz most
Why does SUM look broken for window functions?
TL;DR: SUM is NOT broken A quandary from a work colleague this morning about rolling totals via the SUM aggregation
Much ado about (paying) nothing
A couple of days ago, we announced some more free goodies to Oracle Cloud. As most readers will know, we
Big bits – really long bit strings
A while back we had an AskTom question about arbitrary length addition and subtraction, and so I whipped a small
New Podcast Episode! Every index is a bug
Every database has indexes…but should they? In this episode, lets consider a different proposition. What if the indexes you have
Better performance when querying the V$ views
I’m a big fan of giving developers the tools they need to tune their applications in Production if that is
