Managing and Optimizing INFORMIX-OnLine Dynamic Server Databases: Concurrency, Locking, and Indexing

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 enable the student to manage data access

Learning Objectives

Explain concurrency control. Describe isolation levels. Use locking and lock modes. Describe the different types of index. Create, maintain, and drop an index. Describe the structure of a B+tree. Index appropriate columns. Examine the performance implications of using indexes. Explain parallel sorting.

Topics Covered

Concurrency and locks - Concurrency - Locking granularity and modes Index concepts - About indexes - Index types - Index considerations Index creation and maintenance - Working with indexes - Hands-on: Creating an index - Parallel sorts