Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
admin:optimization:plans:configuration [2012/02/03 18:06]
doc
admin:optimization:plans:configuration [2016/06/28 22:38] (current)
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 statementletting ​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.  ​Firstissue 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]]**
  
  
 ====== Additional Resources ====== ====== Additional Resources ======
 See also: See also:
-{{page>:​admin:​indexing:​see_also&​nofooter&​noeditbtn}}+{{page>:​admin:​optimization:​see_also&​nofooter&​noeditbtn}}
  
 {{page>:​bottom_add&​nofooter&​noeditbtn}} {{page>:​bottom_add&​nofooter&​noeditbtn}}
 
Back to top
admin/optimization/plans/configuration.1328292370.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)