The background story for that is long and complex, so I won’t get into it. I’ll just say that it was related to replication and I wrote a procedure to
Category: Database Development
Using SPM to Control A Single SQL Execution PlanUsing SPM to Control A Single SQL Execution Plan
SQL Plan Management (SPM) is a powerful tool. It can do many things to control and evolve SQL execution plans to allow the most stable system. In this scenario I’ll
Debugging ORA-1775Debugging ORA-1775
ORA-1775 “looping chain of synonyms” can be found online quite easily. But every time they talk about a real loop of synonyms (like syn1 -> syn2 -> syn3 -> syn1)
Ansi Joins and ORA-25154Ansi Joins and ORA-25154
For one of my projects I needed to create all kind of dynamic queries and execute them against different tables. During this step I decided to use ansi joins even
Did You Know #30 – Order in a PredicateDid You Know #30 – Order in a Predicate
I’ve known this for a while but never wrote about it. In KScope19 I attended a session by Alex Nuijten and during the session he asked a question about LIKE
Strange Index BehaviorStrange Index Behavior
During a performance problem I had with a query I wanted to create an index on the table. Since this was a large table I wanted the index to include
Why I Don't Like ANSI JoinsWhy I Don't Like ANSI Joins
Since Oracle started supporting ANSI joins in 9i, the Oracle community was divided into two groups: one loved it and tried to convince everyone to use it, and the other
Top-N QueriesTop-N Queries
This is an old story. It started in 2015 when I found a problem with TOP-N query performance. I wrote a blog post about it and later an update. Here
Oracle 19c – Features We Know AboutOracle 19c – Features We Know About
Oracle Open World was interesting like every year. This year, Oracle started talking about features that will probably be in Oracle 19c (which is the last 12.2 release). The rumor
Getting Crazy with Analytic Functions and Group ByGetting Crazy with Analytic Functions and Group By
This topic has been sitting in my backlog for a long time and I finally decided to write it. Analytic functions are not so new anymore (they’ve been around since