INFORMIX-OnLine Dynamic Server: Fragmentation and PDQ

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 in the INFORMIX-OnLine Dynamic Server System Administration or Managing and Optimizing INFORMIX-OnLine Dynamic Server Databases suites; the course Relational Principles and the SQL Programming suite; a knowledge of the UNIX operating system is necessary (refer to the UNIX curriculum); an understanding of client/server technologies, though not a strict prerequisite, would be useful

Course Aim

To enable the student to use fragmentation and parallel processing to improve database performance

Learning Objectives

Explain the goal of fragmentation. Identify and compare the two types of fragmentation. Design a fragmentation strategy. Create a fragmented table and index. Alter a fragmented table and index. Use fragmentation with RAID. Differentiate between OLTP and DSS queries. Explain parallel queries. Describe the PDQ feature. Implement PDQ to maximize performance for DSS queries. Control parallel query resources. Monitor parallel database queries.

Topics Covered

Fragmentation concepts - About fragmentation - Types of fragmentation - Indexes and fragmentation - Using rowids Using fragmentation - Fragmentation clauses - Hands-on: Fragmenting a table - Guidelines for fragmentation - Altering fragments PDQ concepts - DSS queries and PDQ - Parallel inserts Using PDQ - Managing PDQ resources - Hands-on: Changing PDQ parameters - Monitoring the MGM