This is an old revision of the document!


Administration: Indexing Strategies

Indexing Concepts

Overview

  • Basics of indexing
  • Indexing for criteria
    • Basic cost of qualifications
    • Use of multiple indexes
    • MDK_RETRIEVAL_THRESHOLD (rename to QUALIFICATION_THRESHOLD)
  • Indexing for joins
    • Basic costs of joins
    • Prejoined indexes
    • Joining across databases
  • Indexing for aggregations
    • Basic cost of index scan
    • Use of partition qualifiers
    • ASK_RETRIEVAL_THRESHOLD (rename to AGGREGATION_THRESHOLD)
  • Indexing for ordering
    • Similar to aggregations
  • Indexing for retrieval
    • Obtaining data from indexes
    • Base cost of reading the index
  • Alternatives to indexing
    • Full table scans
    • Sort-merge
    • Hashed data caching

Additional Resources

See also:

 
Back to top
admin/indexing/concepts/home.1295019090.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)