This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:examples:home [2011/04/22 17:03] admin |
dev:sql:examples:home [2012/10/26 14:57] (current) |
||
|---|---|---|---|
| Line 28: | Line 28: | ||
| ===== Partition ===== | ===== Partition ===== | ||
| + | |||
| + | > partition companies by "case when state in ('CA','CO','TX') then '01' when state in ('NY','FL','WA') then '02' else '03' end" ; | ||
| + | Partitioned 31,548 rows from COMPANIES into 3 partitions | ||
| + | |||
| + | |||
| + | |||
| <code> | <code> | ||
| partition households by "case when state in ('CA','CO','TX') then '01' when state in ('AZ','NM','UT') then '02' else '03' end" | partition households by "case when state in ('CA','CO','TX') then '01' when state in ('AZ','NM','UT') then '02' else '03' end" | ||