This shows you the differences between two versions of the page.
|
admin:indexing:concepts:home [2011/01/14 15:31] els |
admin:indexing:concepts:home [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | ====== Administration: Indexing Strategies ====== | ||
| - | |||
| - | ===== Indexing Concepts ===== | ||
| - | |||
| - | **[[admin:indexing:concepts:home|Overview]]** | | ||
| - | [[admin:indexing:concepts:basics|Indexing Basics]] | | ||
| - | [[admin:indexing:concepts:criteria|Criteria]] | | ||
| - | [[admin:indexing:concepts:joins|Table Joins]] | | ||
| - | [[admin:indexing:concepts:aggregations|Aggregations]] | | ||
| - | [[admin:indexing:concepts:ordering|Ordering]] | | ||
| - | [[admin:indexing:concepts:retrieval|Retrievals]] | | ||
| - | [[admin:indexing:concepts:alternatives|Indexing Alternatives]] | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== 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 | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[admin:indexing:concepts:criteria|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:admin:indexing:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||