Overview | Declaring Indexes | Updating Indexes | Standalone Indexes | Index Files | Maintenance

The easiest way to add Omnidex Indexing is to add indexing information beside each column. This will not work in all situations, such as when multi-column indexes are being created; however, it will work in many simpler installations. More complex installations will require the more complex features described in CREATE TABLE and CREATE INDEX. The example below shows the basic addition of Omnidex indexing to the same database.

> CREATE environment
>>  IN                   "simple.xml"
>>  WITH                 DELETE;
Environment created IN simple.xml
>
>
> CREATE DATABASE       "SIMPLE"
>>   TYPE                FILE
>>   index_directory     "idx"
>>  IN                   "simple.xml";
DATABASE SIMPLE created IN simple.xml
>
>
> CREATE TABLE          "HOUSEHOLDS"
>>  physical             "dat/households.dat"
>>  (
>>   "HOUSEHOLD"         CHARACTER(12)     omnidex,
>>   "ADDRESS"           CHARACTER(50)     quicktext,
>>   "CITY"              CHARACTER(28)     quicktext,
>>   "STATE"             CHARACTER(2)      omnidex,
>>   "ZIP"               CHARACTER(5)      omnidex,
>>   "COUNTRY"           CHARACTER(2)      omnidex,
>>   CONSTRAINT HOUSEHOLDS_HOUSEHOLD_PK PRIMARY ("HOUSEHOLD")
>>  )
>>  IN                   "simple.xml";
TABLE HOUSEHOLDS created IN simple.xml
>
>
> CREATE TABLE          "INDIVIDUALS"
>>  physical             "dat/individuals.dat"
>>  (
>>   "INDIVIDUAL"        CHARACTER(12)     omnidex,
>>   "HOUSEHOLD"         CHARACTER(12)     omnidex,
>>   "NAME"              CHARACTER(50)     quicktext,
>>   "GENDER"            CHARACTER(1)      omnidex bitmap,
>>   "BIRTHDATE"         ANSI DATE         omnidex,
>>   "PHONE"             CHARACTER(14)     omnidex,
>>   "EMAIL"             CHARACTER(60)     quicktext,
>>   CONSTRAINT INDIVIDUALS_INDIVIDUAL_PK PRIMARY ("INDIVIDUAL"),
>>   CONSTRAINT INDIVIDUALS_HOUSEHOLD_FK FOREIGN ("HOUSEHOLD") REFERENCES "HOUSEHOLDS"
>>  )
>>  IN                   "simple.xml";
TABLE INDIVIDUALS created IN simple.xml

Prev | Next

See also: