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:indexes:types [2011/01/18 21:19] els |
admin:indexing:indexes:types [2011/01/24 15:27] 127.0.0.1 external edit |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ~~NOTOC~~ | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| Line 12: | Line 13: | ||
| ==== Index Types ==== | ==== Index Types ==== | ||
| - | Omnidex supports four types of indexes: | + | Omnidex supports four types of indexes. These types of indexes provide support for handling Omnidex criteria, table joins, aggregations and ordering. They also support both textual data and non-textual data. Most databases use a combination of these index types to meet their indexing needs. |
| === Omnidex Indexes === | === Omnidex Indexes === | ||
| Line 22: | Line 23: | ||
| An Omnidex Index can also be created with multiple columns. These indexes are valuable for optimizing SQL statements with multiple columns in the GROUP BY clause, ORDER BY clauses or the aggregation functions (COUNT, SUM, MIN, MAX and AVERAGE). | An Omnidex Index can also be created with multiple columns. These indexes are valuable for optimizing SQL statements with multiple columns in the GROUP BY clause, ORDER BY clauses or the aggregation functions (COUNT, SUM, MIN, MAX and AVERAGE). | ||
| + | |||
| + | == Omnidex Bitmap Index - A common variation == | ||
| + | |||
| + | An Omnidex Bitmap Index uses a bitmap storage format to reduce disk space usage and speed performance. Omnidex Bitmap Indexes are appropriate for non-textual columns with thirty or less distinct values. | ||
| === QuickText Indexes === | === QuickText Indexes === | ||