This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:features:expressioncols:optimization [2012/02/05 19:48] doc |
admin:features:expressioncols:optimization [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 31: | Line 31: | ||
| This same technique is appropriate for many types of expressions. For example, a search for area code using criteria of "SUBSTRING(PHONE from 2 for 3) = '303'" can be optimized using a similarly constructed expression-based column. A search for age using criteria of "$COMPARE_DATES(BIRTHDATE, CURRENT_DATE, 'YY') >= 24" can be similarly optimized. This technique creates a wide variety of new oppportunities for optimizing queries using Omnidex indexes. | This same technique is appropriate for many types of expressions. For example, a search for area code using criteria of "SUBSTRING(PHONE from 2 for 3) = '303'" can be optimized using a similarly constructed expression-based column. A search for age using criteria of "$COMPARE_DATES(BIRTHDATE, CURRENT_DATE, 'YY') >= 24" can be similarly optimized. This technique creates a wide variety of new oppportunities for optimizing queries using Omnidex indexes. | ||
| - | |||
| - | |||
| - | |||
| - | |||
| ==== ==== | ==== ==== | ||