Articles & Content

Archives

Informix Online Index Build for 10.0 (K10)

Topic: 2006 NA

Subtopic: Informix



DATE: 2006-05-10 (02:30 PM - 03:40 PM)
SPEAKERS: Nelson Corcoran (IBM)

Informix Server 10.0 contains a new feature that allows DBAs to build indexes online while the table is fully available for updates and retrieval. Using Online Index Build to your best advantage and considerations such as the limited lock time and performance are discussed in this talk.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

What is Online Index Build

Example usages

Duration of exclusive lock on tables

Performance considerations

Temporary tables created and their location



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.