We recommend separating table space by at least one schema per one table space. For best practice we also recommend separating table space for data and table space for index for best performance, but can fine tune by following these techniques:

  • Separate table space for transaction data table and index data table.
  • Separate table space by following data size of table.
  • Place table space file in different physical disk.