News & PR
Get this RSS feed
Tagged Content List
Premature optimization, (probably) because of Donald Knuth’s famous line “premature optimization is the root of all evil,” (see Structured Programming with go to Statements) is, at the very least, a controversial topic. The misconception based on that particular quote is that a programmer, while writing...
Fr, Mrz 15 2013
Index Scan with Filter Predicate Based on a Subquery
Most execution plans can be interpreted by following few basic rules (in TOP, Chapter 6, I provide such a list of rules). Nevertheless, there are some special cases. One of them is when an index scan, in addition to the access predicate, has a filter predicate applying a subquery. The following execution...
Mo, Feb 6 2012
Ad: The Oracle Query Optimizer 2-Day Seminar
The 31st of January and 1st of February 2012 I will present a 2-day seminar about the Oracle query optimizer in Ballerup (DK). The event is organized by Miracle A/S. The content, which is based on the chapters 2, 4, 5, 6, 9 and 10 of my book, is the following: Chapter 1 describes the life [...]
So, Dez 18 2011
optimizer_secure_view_merging and VPD
At page 189 of TOP I wrote the following piece of text: In summary, with the initialization parameter optimizer_secure_view_merging set to TRUE, the query optimizer checks whether view merging could lead to security issues. If this is the case, no view merging will be performed, and performance could...
So, Sep 11 2011
Ad: DOAG Berliner Expertenseminare (Last Call)
I was just informed that there are still some free seats for the 2-day seminar I will present in Berlin in two weeks (June 7-8). Hence, do not wait too long if you want to join us… The content is based on the chapters 4, 5, 6 and 7 of my book, i.e. part 3: Query [...]
Mo, Mai 23 2011
IS NULL Conditions and B-tree Indexes
At page 383 of my book I wrote the following sentence (BTW, the same information is also provided by Table 9-3 at page 381): With B-tree indexes, IS NULL conditions can be applied only through composite B-tree indexes when several SQL conditions are applied and at least one of them is not based on IS...
Do, Feb 17 2011
SIOUG Conference in Portoroz
This is a short note to point out that I just added to the Public Appearances page the next conference organized by the Slovenian Oracle User Group (SIOUG) in Portoroz. It will take place on September 27-29. My talk, entitled “Join Techniques”, is based on chapter 10 of my book. It will be...
Di, Aug 10 2010
Oracle OpenWorld Schedule
Back from two weeks of vacation I noticed that the schedule of the next OpenWorld is available here. The detailled information about my session, which is based on chapter 10 of my book, is the following: ID# S316683 Title Join Techniques Abstract This presentation explains how the query optimizer...
Di, Jul 13 2010
Related-Combine Operation „UNION ALL (RECURSIVE WITH)“
To make easier the interpretation of execution plans, in chapter 6 of TOP I defined three types of operations: standalone operations, unrelated-combine operations, and related-combine operations. For combine operations I also added a list of all operations of each type. Since in 11.2 a new related-combine...
Do, Jun 10 2010
Page 1 of 3 (75 items)