Lesson Summary

• Full table can can be your friend

  • Consider multi-block read count, high water mark, hardware speed, parallel processing

• Index access

  • Know what statistics influence optimizer
  • Understand available paths

Notes: