This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:optimization:home [2012/02/01 20:23] doc |
admin:optimization:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| ===== Introduction to Optimizing Queries ===== | ===== Introduction to Optimizing Queries ===== | ||
| - | |||
| **[[admin:optimization:home|Overview]]** | | **[[admin:optimization:home|Overview]]** | | ||
| - | [[admin:optimization:overview:basics|Query Optimization]] | | ||
| [[admin:optimization:overview:plans|Query Plans]] | | [[admin:optimization:overview:plans|Query Plans]] | | ||
| - | [[admin:optimization:overview:hdc|Data Caches]] | | + | [[admin:optimization:overview:caches|Data Caches]] | |
| [[admin:optimization:overview:config|Configuring Omnidex]] | [[admin:optimization:overview:config|Configuring Omnidex]] | ||
| ---- | ---- | ||
| - | \\ | ||
| ==== Overview ==== | ==== Overview ==== | ||
| Line 27: | Line 24: | ||
| That being said, Omnidex also has it's collection of optimization techniques. Like the underlying database, some of these may involved denormalizing tables or adjusting the SQL statement. Other times, it simply requires using indexing techniques that are highly specific to a particular performance issue. This section will describe these techniques, but keep in mind that the first step is always to understand what the query was originally trying to accomplish, and optimize that problem whenever possible. | That being said, Omnidex also has it's collection of optimization techniques. Like the underlying database, some of these may involved denormalizing tables or adjusting the SQL statement. Other times, it simply requires using indexing techniques that are highly specific to a particular performance issue. This section will describe these techniques, but keep in mind that the first step is always to understand what the query was originally trying to accomplish, and optimize that problem whenever possible. | ||
| - | The first step to improving optimization is to understand [[admin:optimization:overview:plans|Omnidex Query Plans]]. | + | The first step to improving optimization is to understand the [[admin:optimization:overview:plans|Omnidex query plans]]. |
| - | + | ||
| - | + | ||
| - | [[admin:optimization:plans:home| More >]] | + | |
| ===== ===== | ===== ===== | ||
| Line 40: | Line 34: | ||
| ====== 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}} | ||