This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
admin:indexing:overview:advanced [2012/01/20 17:51] doc created |
admin:indexing:overview:advanced [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 5: | Line 5: | ||
====== Administration ====== | ====== Administration ====== | ||
- | ===== Omnidex Indexing ===== | + | ===== Introduction to 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. | + | |
Line 18: | 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 32: | Line 37: | ||
---- | ---- | ||
\\ | \\ | ||
- | **[[admin:indexing:overview:text|Prev]] | [[admin:indexing:overview:applications|Next]]** | + | **[[admin:indexing:overview:text|Prev]]** |