This chapter discusses the performance considerations that are involved when you use table fragmentation.
One of the most frequent causes of poor performance in relational database systems is contention for data that resides on a single I/O device. IBM Informix database servers support table fragmentation (also partitioning), which allows you to store data from a single table on multiple disk devices. Proper fragmentation of high-use tables can significantly reduce I/O contention.
For information about fragmentation and parallel execution, see Parallel Database Query.
For an introduction to fragmentation concepts and methods, see the IBM Informix: Database Design and Implementation Guide. For information about the SQL statements that manage fragments, see the IBM Informix: Guide to SQL Syntax.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]