This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
admin:optimization:plans:configuration [2012/02/03 18:06] doc |
admin:optimization:plans:configuration [2012/02/03 20:02] doc |
||
---|---|---|---|
Line 25: | Line 25: | ||
== COUNTS == | == COUNTS == | ||
- | The COUNTS option will cause the explain to display row counts when known, and timings for certain steps. This option only effects query plans that are run after the query has completed. This is done by issuing the SELECT statement, letting it complete, and then typing the command "EXPLAIN" by itself. | + | The COUNTS option will display row counts and timings in the query plan after certain steps. This option only affects query plans that are run **after** the query has completed. First, issue the query in OdxSQL and let it run to completion, and then issue the "EXPLAIN" command by itself. |
- | Counts and timings can be quite useful toward determine where query performance is most affected. The follow query plan shows the counts and timings for a well-optimized query: | + | Counts and timings can be quite useful in determining where query performance is most affected. The follow query plan shows the counts and timings for a well-optimized query: |
<code> | <code> | ||
Line 71: | Line 71: | ||
== TEXT == | == TEXT == | ||
- | The TEXT option displays more information about the expansion of the query due to the use of PowerSearch. [[admin:indexing:powersearch:home|PowerSearch]] allows a query to locate rows even if they do not exactly match the criteria using techniques like synonyms, misspellings, transpositions, word forms, etc. The TEXT option will show the exact search terms after the query was expanded. | + | The TEXT option displays more information about the expansion of the query due to the use of [[admin:indexing:powersearch:home|PowerSearch]]. PowerSearch allows a query to locate rows even if they do not exactly match the criteria using techniques like synonyms, misspellings, transpositions, word forms, etc. The TEXT option will show the exact search terms after the query was expanded. |
- | The follow query plan shows the expanded search terms for a PowerSearch query. In this example, PowerSearch is being used to find all the synonyms and phonetic equivalents of William, and a wide misspelling search is being used for emails containing Vasquez. The query plan shows that several synonyms for William will be used, and two email addresses that are similar to Vasquez will be included in the search. | + | The follow query plan shows the expanded search terms for a PowerSearch query. In this example, PowerSearch is being used to find all the synonyms and phonetic equivalents of William, and the spelling variations of an email address containing Vasquez. The query plan shows several synonyms for William and two email addresses that are similar to Vasquez. |
<code> | <code> | ||
Line 110: | Line 110: | ||
---- | ---- | ||
\\ | \\ | ||
- | **[[admin:optimization:optimization|Next]]** | + | **[[admin:optimization:plans:optimization|Next]]** |