This shows you the differences between two versions of the page.
|
admin:optimization:plans:reference [2012/02/02 18:28] doc |
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 ==== | ||
| - | |||
| - | An Omnidex query plan is designed to provide all of the essential information needed to understand how a query will be processed, as well as basic suggestions about how to further optimize the query. A great deal can be learned by reviewing the query plan, and it is always the first step in understanding Omnidex query performance. | ||
| - | |||
| - | A query plan consists of two sections: the Summary and the Details. The Summary section shows the SQL statement, the version of Omnidex, any optimization settings or warnings that affect the query, and even occasional suggestions for optimizing the query. The Details section shows the steps that will be executed to satisfy the query. Steps are executed in the order displayed, and are indented as needed to show loops of instructions. | ||
| - | |||
| - | The example below shows the skeleton 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}} | ||