This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:indexes [2009/12/09 15:05] els |
admin:indexing:indexes [2012/10/26 14:26] (current) |
||
|---|---|---|---|
| Line 26: | Line 26: | ||
| ===== Index Types ===== | ===== Index Types ===== | ||
| + | |||
| + | There are several different types of Omnidex indexes. Each is designed for a different scenario, and all can be used in the same search. For each column that is indexed, choose the index type that best meets the needs of the queries. | ||
| === Omnidex Indexes === | === Omnidex Indexes === | ||
| Line 58: | Line 60: | ||
| Omnidex allows SQL expressions to be indexed. Virtual columns can be created that are based on a SQL expression, similar to the approach used in relational views. These columns can then be indexed, queried and retrieved just like a normal column, even though they do not physically exist in the database. | Omnidex allows SQL expressions to be indexed. Virtual columns can be created that are based on a SQL expression, similar to the approach used in relational views. These columns can then be indexed, queried and retrieved just like a normal column, even though they do not physically exist in the database. | ||
| - | Expression-based columns and indexes can be used to index portions of a field using the SUBSTRING function, such as the area code within a phone number. They can be use to index the concatenation of several columns, such as the combinations of all portions of an address. They can be used to perform conditional indexing using the CASE function, such as indexing an phone number only if that number is eligible to be called. | + | Expression-based columns can be used to index portions of a field using the SUBSTRING function, such as the area code within a phone number. They can be use to index the concatenation of several columns, such as the combinations of all portions of an address. They can be used to perform conditional indexing using the CASE function, such as indexing an phone number only if that number is eligible to be called. |
| ===== Index Groups ====== | ===== Index Groups ====== | ||