This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:overview:advanced [2012/01/24 17:36] doc |
admin:indexing:overview:advanced [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 16: | Line 16: | ||
| [[admin:indexing:overview:autocomplete|AutoComplete]] | | [[admin:indexing:overview:autocomplete|AutoComplete]] | | ||
| [[admin:indexing:overview:text|Text]] | | [[admin:indexing:overview:text|Text]] | | ||
| - | **[[admin:indexing:overview:advanced|Advanced]]** | | + | **[[admin:indexing:overview:advanced|Advanced Strategies]]** |
| - | [[admin:indexing:overview:applications|Applications]] | + | |
| ---- | ---- | ||
| - | \\ | ||
| - | === Advanced Strategies === | + | === Advanced Indexing Strategies === |
| + | |||
| + | Omnidex can optimize a great number of queries using a simple indexing strategy, but Omnidex also has many advanced features. Some of these features support optimizing particularly complex queries, with techniques for especially complex criteria, nested queries, table joins, aggregations and ordering. | ||
| + | |||
| + | Omnidex also provides techniques for: | ||
| + | |||
| + | * incorporating large sets of criteria values into a SQL statement, such as a file of zipcodes or a list of customer numbers, without having to construct excessively large statements. | ||
| + | * segmenting complex queries into multiple steps, with each step able to be referenced in subsequent queries. | ||
| + | * performing geographic radius searches using latitude and longitude coordinates | ||
| + | These advanced indexing strategies usually require a good understanding of Omnidex Query Plans. These plans describe the steps that are involved in processing a query, including the use of indexes. These query plans are essential to insuring the best performance for queries. | ||
| Line 30: | Line 37: | ||
| ---- | ---- | ||
| \\ | \\ | ||
| - | **[[admin:indexing:overview:text|Prev]] | [[admin:indexing:overview:applications|Next]]** | + | **[[admin:indexing:overview:text|Prev]]** |