This shows you the differences between two versions of the page.
|
admin:indexing:overview:strategies [2012/01/20 17:45] doc created |
admin:indexing:overview:strategies [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ~~NOTOC~~ | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | |||
| - | ====== Administration ====== | ||
| - | |||
| - | ===== Omnidex Indexing ===== | ||
| - | |||
| - | Omnidex provides a wide variety of indexing capabilities. The simplest applications may simply require a few indexes to be added, but other applications may use many more indexing capabilities. It is useful to get a quick overview of the indexing capabilities of Omnidex. Customers commonly purchase Omnidex for its basic indexing capabilities, only to discover there is more more available. | ||
| - | |||
| - | |||
| - | [[admin:indexing:home|Concepts]] | | ||
| - | [[admin:indexing:overview:indexes|Options]] | | ||
| - | [[admin:indexing:overview:creation|Creation]]** | | ||
| - | [[admin:indexing:overview:strategies|Strategies]] | | ||
| - | [[admin:indexing:overview:activecounts|ActiveCounts]] | | ||
| - | [[admin:indexing:overview:powersearch|PowerSearch]] | | ||
| - | [[admin:indexing:overview:autocomplete|AutoComplete]] | | ||
| - | [[admin:indexing:overview:text|Text]] | | ||
| - | [[admin:indexing:overview:advanced|Advanced]] | | ||
| - | [[admin:indexing:overview:applications|Applications]] | ||
| - | ---- | ||
| - | \\ | ||
| - | |||
| - | === Indexing Strategies === | ||
| - | |||
| - | |||
| - | The simplest strategy used in Omnidex is to index everything, or at least everything that is involved in the queries. This strategy immediately services a wide variety of queries. Most applications then benefit from analyzing the queries and using specific strategies for optimizing table joins, aggregations, grouping and ordering. | ||
| - | |||
| - | Omnidex administrators will strive to have as much of the query processed within the index as possible. A query is consider fully optimized when all aspects are fulfilled by the indexes. In fact, queries that return counts, aggregations, or a few data columns can be fulfilled without ever accessing the data itself, even when the statements involve many table joins, complex criteria, group and ordering. | ||
| - | |||
| - | [[admin:indexing:strategies:home | More >]] | ||
| - | |||
| - | ===== ===== | ||
| - | ---- | ||
| - | \\ | ||
| - | **[[admin:indexing:overview:creation|Prev]] | [[admin:indexing:overview:ActiveCounts|Next]]** | ||
| - | |||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | See also: | ||
| - | {{page>:admin:indexing:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||