This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
admin:indexing:strategies:joins [2011/03/17 21:43] deb |
admin:indexing:strategies:joins [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 29: | Line 29: | ||
| In this example, the HOUSEHOLD column is a primary constraint in HOUSEHOLDS and a foreign constraint in INDIVIDUALS. | In this example, the HOUSEHOLD column is a primary constraint in HOUSEHOLDS and a foreign constraint in INDIVIDUALS. | ||
| - | <code sql> | + | <code> |
| select I.NAME, H.ADDRESS, H.CITY, H.STATE, H.ZIP, I.PHONE | select I.NAME, H.ADDRESS, H.CITY, H.STATE, H.ZIP, I.PHONE | ||
| Line 43: | Line 43: | ||
| In this example, the STATE and COUNTY_CODE is a primary constraint in COUNTIES and a foreign constraint in HOUSEHOLDS. | In this example, the STATE and COUNTY_CODE is a primary constraint in COUNTIES and a foreign constraint in HOUSEHOLDS. | ||
| - | <code sql> | + | <code> |
| select H.ADDRESS, H.CITY, H.STATE, H.ZIP | select H.ADDRESS, H.CITY, H.STATE, H.ZIP | ||
| Line 58: | Line 58: | ||
| This sample environment file shows the Omnidex indexes that will optimize these queries. | This sample environment file shows the Omnidex indexes that will optimize these queries. | ||
| - | <code sql> | + | <code> |
| create environment | create environment | ||
| in "simple.xml" | in "simple.xml" | ||
| Line 64: | Line 64: | ||
| create database "SIMPLE" | create database "SIMPLE" | ||
| - | type FLATFILE | + | type FILE |
| index_directory "idx" | index_directory "idx" | ||
| in "simple.xml"; | in "simple.xml"; | ||
| Line 81: | Line 81: | ||
| create table "HOUSEHOLDS" | create table "HOUSEHOLDS" | ||
| - | physical "dat\households.dat" | + | physical "dat/households.dat" |
| ( | ( | ||
| "HOUSEHOLD" CHARACTER(12) omnidex, | "HOUSEHOLD" CHARACTER(12) omnidex, | ||
| Line 96: | Line 96: | ||
| create table "INDIVIDUALS" | create table "INDIVIDUALS" | ||
| - | physical "dat\individuals.dat" | + | physical "dat/individuals.dat" |
| ( | ( | ||
| "INDIVIDUAL" CHARACTER(12), | "INDIVIDUAL" CHARACTER(12), | ||