Data Vault Queries and Join Elimination
If you work with Data Vault for a data warehouse running in an Oracle database, I strongly recommend to use Oracle 12.2 or higher. Why that? Since Oracle 12c Release 2, join elimination works for more than one join column. This is essential for queries…
Moving to GitHub
Over the years, my blog has become one big mess. It was no longer a blog. It contained product pages, change logs, software downloads, FAQs and even a forum. That was a nice experiment. But now it’s time to move everything that doesn’t belong in…
Update Center for Free SQL Developer Extensions
Introduction In July 2017 Oracle announced to release updates for SQL Developer on a quarterly basis. Installing multiple versions of SQL Developer on the same machine is not a problem. Therefore many developers install a new version as soon as it becomes available. On the…
Small fix for SQLcl Java problem with Oracle 12.1
Let’s say you want to quickly use some cool features of SQLcl inside the script running on the database server, but only Oracle below version 12.2 is available there (which is the first one being shipped with SQLcl). This means that you have to download…
Constants vs. Parameterless Functions
Do you use parameterless PL/SQL functions in your queries? Did you know that this may cause performance issues? In this blog post I explain why parameterless functions can be the reason for bad execution plans in any Oracle Database. I recently had to analyze this…
Conference Review 2019 (Part 3)
In the last four weeks, I had the chance to speak at three different conferences. This was the finish of an intensive conference year for me with many impressions, learning, knowledge sharing, new and old contacts and of course a lot of fun. I am…
Integrate SQL*Plus Scripts in SQL Developer
I envy my DBA colleagues when they work with the Oracle Database from the command line in an incredibly efficient way. They just call a series of scripts with some parameters to get the desired information. Everything looks so easy, so smooth, so natural. I’m…
Partition Pruning and NLS Settings
NLS (National Language Support) parameters are very useful for multilingual applications in an Oracle database. But it is important to understand their impact on query performance. I was aware that NLS is important for indexes, but never thought about its impact on partitioning. In a…
Exadata Cloud at Customer: Real-life experiences
Today again very short post, just pointing to my recent article inside new issue of UKOUG magazine called #PTK (former Oracle Scene): Exadata Cloud at Customer: Real-life experiences. Enjoy! Advertisements
Conference Review 2019 (Part 2)
September was my second round of conferences this year. A presented my session “Avoid Horror Queries: Keep Your SQL Simple and Fast” on three different conferences, two of them organized by Trivadis. POUG 2019 Conference, Wroclaw/Poland For the second time, I joined the POUG conference in Poland….
Social Media @trivadis