Oracle Internal Arch. (contd.)
- segments are used for holding DB objects like tables, clusters, indexes, temporary & rollback segments, partitions & indexed-organized tables. Temporary indexes & temporary tables are automatically cleaned at the session-end.
- table creation involves logical structure (columns) & physical structure (TS, storage parameters). Proper choice of parameters can avoid recreation of tables & indexes.
- break large tables into partitions. Partitions can be based on values in some columns (like dept). Use time in DWH for partitioning. TS of earlier times can be made read-only.