Archive for the ‘Data Warehousing’ Category
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 »
Monday, September 17th, 2007
Many of you are aware of the Oracle 11g Database New Features and while some may be generally interested in new features, one area that I focus on is new features that yield gains in performance. Some of these features can be found in the General Server Performance section ...
Posted in 10gR2, 11gR1, Data Warehousing, Optimizer, Oracle, Performance, Statistics | 15 Comments »
Monday, August 27th, 2007
For those of you who will be attending Oracle OpenWorld 2007 and have interests in the database performance area, I would recommend to you to try and attend the Real-World Performance Group Roundtable session. The session starts with a brief "Hot List" of performance issues that have been predominant ...
Posted in Data Warehousing, Optimizer, Oracle, Performance | No 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 »