About Oracle
Simplicity is the ultimate form of elegance and sophistication
Pages
(Move to ...)
Home
Presentations and papers
▼
Monday, February 19, 2018
Filter predicates with NVL on mandatory columns using the index
›
Last Friday at work, I overheard a conversation between two DBA's about a performance problem of a job which usually ran in 10 minutes, ...
3 comments:
Wednesday, November 23, 2016
Performance aspects of APEX reports
›
As this post appears, I'm presenting on this subject for the Dutch Oracle User Group OGh . This blog post won't contain as much deta...
5 comments:
Thursday, April 30, 2015
Painting the Mona Lisa with SQL
›
Seven years after the first Obfuscated SQL Code Contest , a new one has been organised on the PL/SQL Challenge website. I had fun writing m...
3 comments:
Wednesday, June 18, 2014
9th Planboard DBA Symposium
›
A couple of months ago, Nienke Gijsen invited me to speak about materialized views at the upcoming Planboard DBA Symposium. Because I had th...
Monday, March 31, 2014
APEX World 2014
›
The fifth edition of OGh APEX World took place last Tuesday at Hotel Figi, Zeist in the Netherlands. Again it was a beautiful day full of gr...
Monday, January 6, 2014
Tabibitosan
›
I answered a few SQL questions on Stack Overflow recently, which I could solve easily by using the Tabibitosan method. It's such an eleg...
5 comments:
Thursday, November 28, 2013
INSERT ALL
›
During a performance inspection of some E-Business Suite batch programs running on 11.2.0.3, I noticed almost 99% of the consistent reads mi...
1 comment:
›
Home
View web version