This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
dev:sql:statements:partition:home [2010/07/08 23:03] tdo |
dev:sql:statements:partition:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 5: | Line 5: | ||
===== Description ===== | ===== Description ===== | ||
- | The PARTITION statement reads a table and splits it into multiple sub partitions which can be useful when setting up an Omnidex grid. The output of the PARTITION statement is multiple files that are named as follows: table_name_<distinct_value>.dat. | + | The PARTITION statement reads a table and splits it into multiple sub partitions which can be useful when setting up an Omnidex grid. |
===== Syntax ===== | ===== Syntax ===== | ||
Line 16: | Line 16: | ||
[WITH options] | [WITH options] | ||
</code> | </code> | ||
+ | ===== Discussion ===== | ||
+ | |||
+ | The output of the PARTITION statement is multiple files that are named as follows: table_name_<distinct_value>.dat. | ||
+ | |||
===== Examples ===== | ===== Examples ===== | ||
==== Partition by Column ==== | ==== Partition by Column ==== | ||
Line 45: | Line 49: | ||
… | … | ||
</code> | </code> | ||
+ | ==== Partition with criteria and CASE ==== | ||
The partition statement is used with criteria to split a table into multiple components. | The partition statement is used with criteria to split a table into multiple components. | ||