Re: Using HP Loader question on Indexes

HPL does a set indexes, constraints... disabled; (normal sql to disable index updates ...) and creates vio and diag tables (start violation......) i would create an sql script which creates the indexes after the load. (control it otherwise you're dependant on hpl...) > One more question: I can use HP Loader to load directly from one table into another, correct ? a bit long ago correct me if i'm wrong please... nope or.... more or less.... for i in <number of cpus.....> do create fifo /tmp/fifo$i done use the fifos to create a dev array for loading and unloading. table you want to get the data from, create(generate) unload job for it using dev array fifos unloading table you want to load data into : create (generate) load job for it using dev array fifos loading Superboer.