Selecting a Table Architecture

When designing your table, consider the following design criteria:

• LOB storage
  • Where are NULL Values in a LOB Column Stored?

  • Defining Tablespace and Storage Characteristics for Internal LOBs

  • LOB Storage Characteristics for LOB Column or Attribute

  • TABLESPACE and LOB Index
    • PCTVERSION

    • CACHE / NOCACHE / CACHE READS

    • LOGGING / NOLOGGING

    • CHUNK

    • ENABLE | DISABLE STORAGE IN ROW

  • How to Create Gigabyte LOBs

• LOBs in Index Organized Tables (IOT)

• Manipulating LOBs in Partitioned Tables

• Indexing a LOB Column