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 16:49] admin |
dev:sql:examples:home [2012/10/26 14:57] (current) |
||
|---|---|---|---|
| Line 20: | Line 20: | ||
| odxsql> EXTRACT DDL to myfile.sql; | odxsql> EXTRACT DDL to myfile.sql; | ||
| </code> | </code> | ||
| + | |||
| + | EXTRACT DDL to myfile.sql WITH DELETE; | ||
| ===== CONNECT WITH MAINTENANCE ===== | ===== CONNECT WITH MAINTENANCE ===== | ||
| Line 26: | 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" | ||
| Line 112: | Line 120: | ||
| update indexes with log=odxlogs; | update indexes with log=odxlogs; | ||
| + | |||
| + | Update Indexes with limiting the rows being read and indexed per table. | ||
| + | <code> | ||
| + | os> odxsql | ||
| + | > connect myenv.xml; | ||
| + | > create directory odxlogs; | ||
| + | > setenv oa_max_rows=100000; | ||
| + | > update indexes with log=odxlogs; | ||
| + | > setenv oa_max_rows | ||
| + | > update indexes with log=odxlogs; | ||
| + | > exit | ||
| + | os> | ||
| + | </code> | ||
| + | |||
| + | |||
| + | UPDATE INDEXES WITH BUF=n | ||
| + | |||
| + | N is the number of MB to use in the build, and coincides with the BUF= in the build command in dbinstal. | ||
| + | |||
| + | |||
| ===== $CONTAIN Function ===== | ===== $CONTAIN Function ===== | ||