Home | Previous Page | Next Page   Tuning Database Server Performance > Tuning I/O for Tables and Indexes >

Duplicate Copies of Small Tables

For OLTP transactions and some DSS queries, you might improve performance by encouraging local lookups if each coserver contains a copy of a frequently accessed table.

The following kinds of tables are candidates for duplication:

For detailed information about the CREATE DUPLICATE OF TABLE and DROP DUPLICATE OF TABLE, statements, see the IBM Informix: Guide to SQL Syntax.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]