Managing and Optimizing INFORMIX-OnLine Dynamic Server Databases: Cost-Based Optimization

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Application developers, database and system administrators, and technical support personnel

Prerequisites

Previous courses from the Managing and Optimizing INFORMIX-OnLine Dynamic Server Databases suite; the course Relational Principles and the SQL Programming suite; a knowledge of UNIX is necessary (refer to the UNIX curriculum); an understanding of client/server technologies, though not a strict prerequisite, would be useful

Course Aim

To familiarize the student with factors that influence the optimization of database performance

Learning Objectives

Discuss the cost-based optimizer. Describe the optimization process. Describe join strategies and query paths. Influence the optimizer's path choice. Use the SET EXPLAIN statement. Examine the optimizer's query plan. Improve the statistical accuracy available to the optimizer. Create distributions. Display distribution information. Implement the guidelines for creating distributions.

Topics Covered

About cost-based optimization - Join strategies - Query paths and OPTCOMPIND - The optimization process Using SET EXPLAIN - About SET EXPLAIN - Optimizing joins, filters, and indexes Statistics and distributions - UPDATE STATISTICS - Distributions - Distribution guidelines - Hands-on: Using UPDATE STATISTICS