IBM® Informix® 12.10

Expelling long strings

The most bulky attributes are often character strings. To make the rows shorter, you can remove long strings from the entity table.

You can use the following methods to expel long strings:
  • Use VARCHAR columns.
  • Use TEXT data.
  • Move strings to a companion table.
  • Build a symbol table.
Parent topic: Denormalize the data model to improve 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.