This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:optimization:home [2010/07/28 13:23] els |
admin:optimization:home [2012/10/26 14:51] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ~~NOTOC~~ | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| Line 4: | Line 5: | ||
| ===== Overview ===== | ===== Overview ===== | ||
| + | **[[admin:queries:overview|Overview]]** | [[admin:queries:plans|Query Plans]] | [[admin:queries:logging|Query Logs]] | [[admin:queries:benchmark|Benchmarks]] | ||
| Many of the optimization strategies in Omnidex involve Omnidex indexing, but some also use features of the SQL engine. These include a wide variety of techniques that are discussed in this section: | Many of the optimization strategies in Omnidex involve Omnidex indexing, but some also use features of the SQL engine. These include a wide variety of techniques that are discussed in this section: | ||
| + | * [[admin:optimization:powersearch:home|PowerSearch - Finding Data without Exact Criteria]] | ||
| * [[admin:optimization:rollups:home|Rollup Tables - Optimizing Counts and Aggregations]] | * [[admin:optimization:rollups:home|Rollup Tables - Optimizing Counts and Aggregations]] | ||
| * [[admin:optimization:temptables:home|Temporary Tables - Taking Advantage of Temporary Tables]] | * [[admin:optimization:temptables:home|Temporary Tables - Taking Advantage of Temporary Tables]] | ||