Oracle Database 11g: Execution Plans and Star Transformations
»Oracle Database 11g: SQL Tuning
| Duration : | --- |  |
Status : | Active |
| Created date : | Fri, 08/28/2009 - 01:25 | Last modified date : | Fri, 08/28/2009 - 01:25 | |
| Course owner : | Myenzone Admin | Highlighted : | No | |
| Type : | Individual | |||
| Rating : | 0 | |||
| Instructor : | ---- | |||
| References : | Oracle Database 11g: SQL Tuning | |||
| Tags : | 11g, Oracle, Oracle10g, Oracle11g | |||
| Topics covered : | ||||
| Credits : | Not available | |||
| Short description : | This course explores gathering, displaying, and interpreting execution plans. It also covers the EXPLAIN PLAN command and the PLAN_TABLE, using AUTOTRACE, dynamic performance views that contain execution plan information, the Automatic Workload Repository (AWR), and SQL monitoring. The star schema is the simplest data warehouse schema. Defining a star schema and star transformation requirements, as well as star query plans without transformation and after transformation, are also covered. |
|||
| Description : | An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting execution plans. It also covers the EXPLAIN PLAN command and the PLAN_TABLE, using AUTOTRACE, dynamic performance views that contain execution plan information, the Automatic Workload Repository (AWR), and SQL monitoring. The star schema is the simplest data warehouse schema. Defining a star schema and star transformation requirements, as well as star query plans without transformation and after transformation, are also covered. |
|||
View comment |
||||
