This shows you the differences between two versions of the page.
|
admin:optimization:plans:reference [2012/02/02 18:24] doc created |
admin:optimization:plans:reference [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ~~NOTOC~~ | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | |||
| - | ====== Administration: Optimizing Queries ====== | ||
| - | |||
| - | ===== Query Plans ===== | ||
| - | |||
| - | |||
| - | [[admin:optimization:plans:home|Overview]] | | ||
| - | **[[admin:optimization:plans:reference|Anatomy of a Query Plan]]** | | ||
| - | [[admin:optimization:plans:example|Reading a Query Plan]] | | ||
| - | [[admin:optimization:plans:configuration|Configuring Query Plans]] | | ||
| - | [[admin:optimization:plans:optimization|Optimizing Queries]] | ||
| - | |||
| - | ---- | ||
| - | \\ | ||
| - | |||
| - | ==== Anatomy of a Query Plan ==== | ||
| - | |||
| - | <code> | ||
| - | ----------------------------------- SUMMARY ----------------------------------- | ||
| - | <SQL Statement> | ||
| - | |||
| - | Version: <Omnidex version> | ||
| - | Request Opt: <Requested optimization settings> | ||
| - | Optimization: <Actual optimization settings> | ||
| - | Warnings: <Warning flags> | ||
| - | Notes: <Optimization notes> | ||
| - | ----------------------------------- DETAILS ----------------------------------- | ||
| - | <Query processing step 1> | ||
| - | <Query processing step 2> | ||
| - | <Query processing step 3> | ||
| - | ... | ||
| - | ------------------------------------------------------------------------------- | ||
| - | </code> | ||
| - | |||
| - | |||
| - | ===== ===== | ||
| - | ---- | ||
| - | \\ | ||
| - | **[[admin:optimization:home|Prev]]** | | ||
| - | **[[admin:optimization:example|Next]]** | ||
| - | |||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | See also: | ||
| - | {{page>:admin:indexing:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||