IBM® Informix® 12.10

Distribution schemes for reusing indexes

You can use one of three distribution schemes that allow the attach operation of the ALTER FRAGMENT statement to reuse existing indexes.

These distributions schemes are:
  • Fragmenting the index in the same way as the table
  • Fragmenting the index with the same set of fragment expressions as the table
  • Attaching unfragmented tables to form a fragmented table
Parent topic: Improving ALTER FRAGMENT ATTACH performance

Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.