PARTITION
Partition a table.
This command partitions a table and can optionally generate the Omnidex
environment file entries necessary to index and search the partitioned
table.
This
command is provided as a convenience but is not required to be used in
order to take advantage of partitioning in an Omnidex application.
The partitioned data will be put into flat files which are stored in
either the same location as the environment file (default) or the location
specified by the IN path clause.
Two files, partition.log and partition.rpt, will be generated detailing
exactly how the partition was created.
Use the REPORT_ONLY option to generate these reports without actually
partitioning the data.
Syntax
PARTITION table [INTO n [PARTITIONS]] [BY column] [IN path]
[WITH options]
PARTITION
Required.
table
Required. The name of the table, as defined in the Omnidex environment
file, to be partitioned.
INTO n PARTITIONS
Optional. n is an integer representing the number of physical partitions
to be created. The INTO keyword is required is specifying the number of
partitions. The PARTITION keyword is optional and is supported only for
visual clarity.
BY column
Optional. column is the partition qualifier, the column on which the partition
is based. The By keyword is required when specifying the column.
Although
this clause is optional, it is highly recommended that it not be omitted.
IN path
Optional. path is the physical location where the partitions should be
placed. The IN keyword is required when specifying the path.
WITH options
Optional. A comma separated list of options to apply to this command.
Options
REPORT_ONLY
Example
This example partitions the orders table in the star database
>PARTITION orders into 5 by product_no in dat with environmentsnippet
= snippet.txt
Partitioned 200 rows into 5 partitions
>view partition.rpt
Top
|