This shows you the differences between two versions of the page.
admin:indexing:home [2009/12/09 00:12] els |
admin:indexing:home [2012/10/26 14:26] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{page>:top_add&nofooter&noeditbtn}} | ||
- | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
- | ====== Omnidex Indexes ====== | ||
- | |||
- | Omnidex adds performance and flexibility to database applications. These benefits are achieved by a combination of the Omnidex indexes and the Omnidex SQL Engine. The indexes provide the basic speed and flexibility, while the SQL Engine analyzes statements and determines the best way to use the indexes. Omnidex is different than most SQL engines in that many indexes are used to fulfill a query. It is common for all criteria, table joins, aggregations and ordering to be satisfied in a coordinated effort between many indexes. Complex queries may even be satisfied without ever accessing the underlying data. | ||
- | |||
- | Three basic types of indexes allow SQL statement to be optimized and provide features such as textual search, fuzzy searches and geographical searches. Installation can be as simple as placing indexes on the columns involved in a query. A collection of advanced options allow access to specialized features that are useful for individual situations. | ||
- | |||
- | Omnidex indexes are easily created using either the Omnidex Administrator or Omnidex SQL statements. Indexes can be built in batch, greatly reducing the time required to build the indexes. | ||
- | |||
- | The following questions are frequently asked about Omnidex indexing: | ||
- | |||
- | - [[#What_does_an_Omnidex_index_do|What does an Omnidex index do?]] | ||
- | - [[#How_are_Omnidex_indexes_different_than_relational_indexes|How are Omnidex indexes different than relational database indexes?]] | ||
- | - [[#What_kinds_of_Omnidex_indexes_are_there?|What kinds of Omnidex indexes are there?]] | ||
- | - [[#How_do_you_create_Omnidex_indexes|How to you create Omnidex indexes?]] | ||
- | |||
- | |||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |