Archive for the ‘SQL Tuning’ Category
Monday, November 19th, 2007
Oracle OpenWorld 2007 has come and gone and from the Real-World Performance Group's perspective we'd consider it a successful one. The content of this year's presentations seems to have gone over quite well as shown by the number of hallway comments and emails we received. At least two ...
Posted in Data Warehousing, Execution Plans, Optimizer, Oracle, Performance, SQL Tuning, Statistics, VLDB | 3 Comments »
Wednesday, October 31st, 2007
In the Real-World Performance Roundtable, Part 2: The Optimizer, Schema Statistics, SQL Tuning at Oracle OpenWorld 2006, I worked an example of how the optimizer can have difficulty estimating the correct cardinality when there is data correlation. (The Zodiac example can be found on pages 46-49 of the presentation.) ...
Posted in 11gR1, Data Warehousing, Execution Plans, Optimizer, Oracle, SQL Tuning, Statistics, VLDB | 8 Comments »
Tuesday, October 23rd, 2007
The other day I was reading the 11g Database VLDB and Partitioning Guide and came across the below execution plan for a partial partition-wise join between sales and customers.
---------------------------------------------------------------------------
| Id | Operation ...
Posted in Execution Plans, Optimizer, Oracle, SQL Tuning | 2 Comments »
Friday, August 24th, 2007
Recently, I've been quite busy with performance projects and haven't had the spare time I would like to keep up on my blog. Now that those projects are behind me, I wanted to blog about the use of one feature that made a significant difference in performance on a ...
Posted in Data Warehousing, Execution Plans, Optimizer, Oracle, Performance, SQL Tuning | 1 Comment »