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.

Copyright© 2019 HCL Technologies Limited