This presentation by a member of the EMC Documentum performance team discusses how to identify poorly performing in a Documentum application and leads the viewer through the query tuning process. Basic concepts about database optimizers and execution plans are discussed to lay the foundwork for the tuning process.
Identifying and interpreting the execution plan and understanding what things can be done to change the execution plan to improve performance are demonstrated. Database-level tasks are demonstrated for both Oracle and SQL Server back end databases. After this seminar, the viewer will have a good foundation on how to improve application performance by reducing query response time.
Content retrieved from: http://159.89.50.151/2011/12/dql-tuning-for-emc-documentum/.
