This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:home [2009/12/09 00:09] els |
admin:indexing:home [2012/10/26 14:26] (current) |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| <html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | ====== Omnidex Indexes ====== | + | ====== Omnidex Indexing ====== |
| - | 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 can be used to fulfill each query. It is common for all criteria, table joins, aggregations and ordering to be satisfied in a coordinated effort among many indexes. Queries may not even require access to the underlying database, despite their complexity. | + | **[[admin:indexing:home|Overview]]** -> [[admin:indexing:indexes|Indexes]] -> [[admin:indexing:basic|Strategies]] -> [[admin:indexing:advanced|Advanced]] -> [[admin:indexing:installation|Installation]] -> [[admin:indexing:maintenance|Maintenance]] |
| - | Three basic types of Omnidex indexes allow general SQL statement to be optimized, and also provide features including textual search, fuzzy searches and geographical searches. For advanced users, a collection of 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. | + | ===== Overview ===== |
| - | The following questions are frequently asked about Omnidex indexing: | + | Omnidex adds performance and flexibility to database applications. These benefits are achieved by a combination of the Omnidex indexes and the [[admin:sqlengine:home|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. |
| - | - [[#What_does_an_Omnidex_index_do|What does an Omnidex index do?]] | + | Three basic types of indexes allow SQL statements to be optimized. They also provide features such as textual searches, fuzzy searches and geographical searches. Standard Omnidex indexes provide the bulk of Omnidex functionality, optimizing criteria, table joins, aggregations and ordering. QuickText indexes provide basic textual searches on columns like name and address fields, product descriptions and general text. FullText indexes provide sophisticated text indexing designed for large blocks of textual data. |
| - | - [[#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?]] | + | |
| + | Omnidex also has advanced options that optimize complex or unusual situations. One example is Index Groups, in which multiple columns are indexed as though they were one column. Another example is geographic indexes which index latitude and longitude coordinates in preparation for geographic radius searches. | ||
| + | |||
| + | Omnidex Indexes are installed by simply designating indexes on the columns involved in a query. There are times when indexing options are valuable, and there are also times when multi-column indexes are created. Once the indexes are designated, all indexes can be built concurrently, greatly reducing the time required to build the indexes. | ||
| + | |||
| + | To learn more about Omnidex indexing, read the following sections: | ||
| + | |||
| + | - [[admin:indexing:indexes|Omnidex indexes]] | ||
| + | - [[admin:indexing:basic|Basic indexing strategies]] | ||
| + | - [[admin:indexing:advanced|Advanced indexing strategies]] | ||
| + | - [[admin:indexing:installation|Index installation]] | ||
| + | - [[admin:indexing:maintenance|Index maintenance]] | ||
| + | |||
| + | ====== ====== | ||
| + | \\ | ||
| + | |||
| + | ---- | ||
| + | |||
| + | \\ | ||
| + | |||
| + | |||
| + | The next section on Omnidex Indexing is [[admin:indexing:indexes|Omnidex Indexes]]. | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||