PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
Concepts and Features
Query the statistics in the database for table and catalog statistics.
Create the PLAN_TABLE.
Determine which indexes are associated with a table.
Run an EXPLAIN on a program.
Run an EXPLAIN on two statements provided by the instructor.
Review the PLAN_TABLE to determine joins method used for the step, prefetch techniques and method used to access the table.
Review the STATEMENT_TABLE and determine type of query being explained, and estimated total cost in timerons.
Locate and review the principle statistics effect performance of a query.
Determine the access path for a query and modify the query to change the access path.
Interpreting Data Access
Using the PLAN_TABLE, determine the performance issue with a query and repair the problem.
Determine how many sorts are being performed on a query and why.
Determine the type of join being performed; modify the query to use a different join type.
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.