This module covers performance and tuning concepts, what system resources affect performance, and how tuning often requires that you give up one aspect of performance, to gain another.
Participants learn to use system functions for monitoring the performance of specific queries.
This module defines Index Structures and illustrates how they enable faster access to data. Sections of this module define the storage of data tables, supplemental storage structures and specific query performance. This module examines how the Query Optimizer creates a plan for processing queries and how you can create useful indexes that enable the optimizer to choose the optimal plan. Creating useful indexes by matching them with the proper queries is a large part of the tuning process. We start this module with a section on Index Guidelines, including how to choose indexes and when to build them.