| Presentation Title: | Execution Plans |
| Speaker: | Mr Christian Antognini |
| Company: | Trivadis AG |
| Co-presenter: | |
| Presentation abstract: | An execution plan describes the operations carried out by the SQL engine to execute a SQL statement. Every time you have to analyze a performance problem related to a SQL statement, or simply question the decisions taken by the query optimizer, you must know the execution plan. Whenever you deal with an execution plan, you carry out three basic actions: you obtain it, you interpret it, and you judge its efficiency. The aim of this session is to describe in detail how you should perform these three actions. |
| Presentation begins: | 05/12/2008 10:00 |
| Presentation duration: | 120 |
| Presentation content level: | 3 (1 = indepth, 5 = strategic overview) |
| Audience experience: | Experienced (2-3 years) |
| Audience function: | DBA's, Developers |
| Speaker biography: | Since 1995, Christian Antognini has been focusing on understanding how the Oracle database engine works. His main interests range from logical and physical database design, the integration of databases with Java applications, to the query optimizer and basically everything else related to performance management. He is currently working as a principal consultant and trainer at Trivadis in Zürich, Switzerland. If he is not helping one of his customers to get the most out of Oracle, he is somewhere lecturing on optimization. Christian is member of the Trivadis Performance Team and of the OakTable Network. He is the author of Troubleshooting Oracle Performance (Apress, 2008). |
| Related topics: | Server Technology: Performance Tuning and Diagnostics |
| Hall: | 6 |
