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:04] 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 ==== | ||