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" |