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:22] 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 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 === |