por | 7 octubre, 2013
  • You must dump & load in order to reconfigure to type 2 storage.
  • Type II storage areas —  for data, for indexes and  LOBs , if you have any word indexes put those in their own storage area also.
  • NOTHING EXCEPT SCHEMA should be in the schema area.
  • In order for an area to be type 2 it must have a blocks per cluster of at least 8
  • If you have large tables (more than 1GB) they could go in an area with a cluster size of 512.

Storage Optimization Strategies PowerPoint Download