This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
admin:indexing:indexes:groups [2011/03/18 16:49] deb |
admin:indexing:indexes:groups [2011/03/18 17:45] deb |
||
---|---|---|---|
Line 79: | Line 79: | ||
</code> | </code> | ||
- | As discussed above, care should be taken when considering where to use Index Groups across tables. It can be confusing that when a table is searched without it being included in the SQL statement. A row can also be qualified when a portion of the criteria exists in the parent and another portion exists in a child row. For example, the following search will also locate this household: | + | As discussed above, care should be taken when considering where to use Index Groups across tables. It can be confusing when a table is actually searched without it being referenced in the SQL statement. A row can also be qualified when a portion of the criteria exists in the parent and another portion exists in a child row. For example, the following search will also locate this household: |
<code sql> | <code sql> |