This shows you the differences between two versions of the page.
|
admin:indexing:advanced:joins [2012/02/15 21:20] doc created |
admin:indexing:advanced:joins [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ~~NOTOC~~ | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | |||
| - | ====== Administration: Indexing Strategies ====== | ||
| - | |||
| - | ===== Advanced Strategies ===== | ||
| - | |||
| - | [[admin:indexing:advanced:home|Overview]] | | ||
| - | [[admin:indexing:advanced:criteria|Criteria]] | | ||
| - | **[[admin:indexing:advanced:joins|Joins]]** | | ||
| - | [[admin:indexing:advanced:subqueries|Subqueries]] | | ||
| - | [[admin:indexing:advanced:distinct|Distinct]] | | ||
| - | [[admin:indexing:advanced:ordering|Ordering]] | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== Overview ==== | ||
| - | |||
| - | A basic indexing strategy accommodates most queries, but there are advanced techniques that optimize more unusual situations. Queries with particularly complex criteria or complex table relationships can be optimized using these techniques. Omnidex also has features designed specifically to optimize distinct counts and other complex aggregations. | ||
| - | |||
| - | Before embarking on these techniques, it is important to understand [[admin:optimization:plans:home|Omnidex Query Plans]]. These plans describe the steps that are involved in processing a query, including the use of indexes. These query plans are essential to insuring the best performance for queries. | ||
| - | |||
| - | == Criteria == | ||
| - | * Composite indexes | ||
| - | * Expression-based Indexes | ||
| - | * Rollup tables | ||
| - | * Categorizing data | ||
| - | |||
| - | == Joins == | ||
| - | * Prejoined indexes | ||
| - | * Denormalization | ||
| - | * Multi-level hierarchies | ||
| - | * Record-complex indexing | ||
| - | |||
| - | == Subqueries == | ||
| - | * Structure of subqueries | ||
| - | * Joins instead of subqueries in FROM | ||
| - | * | ||
| - | |||
| - | == Distinct operations == | ||
| - | * Composite indexes | ||
| - | * Grids: Distinct constraints | ||
| - | |||
| - | == Group By == | ||
| - | * Composite indexes | ||
| - | * Rollup tables | ||
| - | * Grids: Distinct constraints | ||
| - | |||
| - | == Order By == | ||
| - | * Composite indexes | ||
| - | * | ||
| - | |||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[admin:indexing:advanced:criteria|Prev]]** | | ||
| - | **[[admin:indexing:advanced:subqueries|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:admin:indexing:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||