This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
admin:indexing:home [2009/12/09 04:21] els |
admin:indexing:home [2009/12/09 04:32] els |
||
|---|---|---|---|
| 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 ====== |
| - | **[[admin:indexing:home|Overview]] -> [[admin:indexing:types|Index Types]] -> [[admin:indexing:basic|Basic Strategies]] -> [[admin:indexing:advanced|Advanced Strategies]] -> [[admin:indexing:installation|Installation]] -> [[admin:indexing:maintenance|Maintenance]] | + | **[[admin:indexing:home|Overview]]** -> [[admin:indexing:indexes|Indexes]] -> [[admin:indexing:basic|Strategies]] -> [[admin:indexing:advanced|Advanced]] -> [[admin:indexing:installation|Installation]] -> [[admin:indexing:maintenance|Maintenance]] |
| - | ---- | + | |
| + | ===== Overview ===== | ||
| 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. | 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. | ||
| Line 16: | Line 17: | ||
| 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. | 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. | ||
| - | ===== How are Omnidex indexes different than relational database indexes? ===== | + | To learn more about Omnidex indexing, read the following sections: |
| - | ===== How are Omnidex indexes created? ===== | + | - [[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]] | ||
| - | ===== What types of Omnidex indexes may I choose from? ===== | + | ====== ====== |
| + | \\ | ||
| + | ---- | ||
| + | \\ | ||
| + | |||
| - | The following questions are frequently asked about Omnidex indexing: | + | The next section on Omnidex Indexing is [[admin:indexing:indexes|Omnidex Indexes]]. |
| - | + | ||
| - | - [[#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}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||