This shows you the differences between two versions of the page.
|
admin:indexing:strategies:criteria [2011/04/13 03:32] 127.0.0.1 external edit |
admin:indexing:strategies:criteria [2012/01/30 17:45] doc |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| + | |||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| Line 24: | Line 25: | ||
| <code sql> | <code sql> | ||
| + | |||
| select HOUSEHOLD, ADDRESS, CITY, STATE, ZIP | select HOUSEHOLD, ADDRESS, CITY, STATE, ZIP | ||
| from HOUSEHOLDS | from HOUSEHOLDS | ||
| Line 29: | Line 31: | ||
| (STATE = 'IL' and CITY = 'Chicago')); | (STATE = 'IL' and CITY = 'Chicago')); | ||
| </code> | </code> | ||
| + | |||
| The STATE and CITY columns should be Omnidex indexes. | The STATE and CITY columns should be Omnidex indexes. | ||
| Line 37: | Line 40: | ||
| <code sql> | <code sql> | ||
| + | |||
| select INDIVIDUAL, NAME, PHONE | select INDIVIDUAL, NAME, PHONE | ||
| from INDIVIDUALS | from INDIVIDUALS | ||
| where BIRTHDATE = 'Jan 10, 1986' and NAME = 'John'; | where BIRTHDATE = 'Jan 10, 1986' and NAME = 'John'; | ||
| </code> | </code> | ||
| + | |||
| The BIRTHDATE column should be an Omnidex index and the NAME column should be a Quicktext index. | The BIRTHDATE column should be an Omnidex index and the NAME column should be a Quicktext index. | ||
| Line 49: | Line 54: | ||
| <code sql> | <code sql> | ||
| + | |||
| select INDIVIDUAL, NAME, PHONE | select INDIVIDUAL, NAME, PHONE | ||
| from INDIVIDUALS | from INDIVIDUALS | ||
| Line 54: | Line 60: | ||
| </code> | </code> | ||
| - | The GENDER column should be an Omnidex Bitmap, and the NAME column should be a QuickText index. | + | |
| + | The GENDER column should be an Omnidex Bitmap index, and the NAME column should be a QuickText index. | ||
| == Sample Environment File == | == Sample Environment File == | ||