Changing tables to improve performance

You can change tables to improve performance by dropping indexes, attaching or detaching fragments, and altering table definitions. You can also create databases for decision-support applications by unloading and loading tables in OLTP databases.

You might want to change an existing table for various reasons:
  • To refresh large decision-support tables with data periodically
  • To add or drop historical data from a certain time period
  • To add, drop, or modify columns in large decision-support tables when the need arises for different data analysis

Copyright© 2019 HCL Technologies Limited