...
>> control osim unload 'osim' ;
Tip: If your OSIM data involves a table with many salted partitions (say, 100 or more), and you have an index on the table that has "SALT_LIKE_TABLE" in its DDL, the CREATE INDEX command will use LOAD under the covers to load it. This can be very slow on a workstation because it will fire up one ESP per partition. This of course is unnecessary as the table is actually empty. To work around this inefficiency, do the following: CQD TRAF_LOAD_USE_FOR_INDEXES 'OFF'. Do this before doing CONTROL OSIM LOAD. Another way to do this is to insert this CQD into the "_MD_".DEFAULTS table before doing CONTROL OSIM LOAD.