...Miscellaneous…

• Outline Editing

  • Update (DML) stored outlines

• More new hints

  • R1: NL_AJ, NL_SJ, FACT, NO_FACT
  • R2: EXPAND_GSET_TO_UNION

• Remember from the chapter on Indexes:

  • Bitmap Join Indexes
  • Skip Scan index access
  • Index Monitoring

Notes: