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 ===== | ||
| <code> | <code> | ||
| Line 16: | Line 17: | ||
| </code> | </code> | ||
| ===== Discussion ===== | ===== Discussion ===== | ||
| + | |||
| + | The output of the PARTITION statement is multiple files that are named as follows: table_name_<distinct_value>.dat. | ||