| |
|
|
|
|
|
|
|
|
Thursday, October 29th 2009 |
|
|
|
|
|
8:00 AM - 9:00 AM |
|
Check-in and complimentary breakfast |
|
|
|
|
|
|
|
|
|
9:00 AM - 10:30 AM |
|
Background - 1.5 hours |
|
|
|
|
In which we examine the need for a global view point and a general strategy for minimising work while recognizing that there will always be a conflict between local and global optimization. A quick review of use of indexes, including some of the less common uses and common errors in index design. Closing with the need to be able to investigate and understand the data and business requirements. |
|
|
|
|
|
|
|
|
|
10:30 AM - 11:00 AM |
|
Coffee and informal discussion: - 30 minutes |
|
|
|
|
|
|
|
|
|
11:00 AM - 12:30 PM |
|
Basic Practices - 1.5 hours |
|
|
|
|
How to approach the task of translating business requirements into SQL. The need for clarity in code, with a suggested set of standards for presentation to improve ease of understanding. An introduction to the essential strategy for writing SQL that gets its result by doing the minimum work, and a model for investigating and re-engineering badly performing statements. |
|
|
|
|
|
|
|
|
|
12:30 PM - 1:30 PM |
|
Lunch and informal discussion: - 1 hour |
|
|
|
|
|
|
|
|
|
1:30 PM - 3:00 PM |
|
Sundry Methods - 1.5 hours |
|
|
|
|
A brief discussion of the mechanics (and costing) of nested loop and hash joins, and why it's so easy it is for the optimizer to pick the wrong option. A few examples demonstrating classic problems, and solutions that take advantage of some of the slightly exotic options of SQL and Oracle's available features. And a few closing comments about the need for the front-end code to co-operate with the database engine in certain circumstances. |
|
|
|
|
|
|
|
|
|
3:00 PM - 3:30 PM |
|
Coffee and informal discussion: - 30 minutes |
|
|
|
|
|
|
|
|
|
3:30 PM - 5:00 PM |
|
More Methods - 1.5 hours |
|
|
|
|
Fixing the code without touching the code - the latest options, including a little time looking at the ways in which you can use OEM to assist with tuning. Problems and options with knowing internal mechanisms and taking advantage of them. A look at a couple of popular requirements, and strategies for addressing them as efficiently as possible. And a final look at the threats of hints and how to use them properly. |
|
|
|
|
|
|
|
|
View all Seminars |
