SPLICE Without an internal sort

Phil WHitehurst · New User Joined: 07 Feb 2009 Posts: 1 Location: UK

Hi,

Is it possible to do a ICETOOL SPLICE without an internal sort?

We are doing some splicing where the files to be spliced are already in the correct sequence for the ON field.

I have noticed that the SPLICE function does an internal sort on the ON field. For some of our larger datasets (10 million + records) this sort must be a significantly overhead in the CPU / I/O cost of the splice?

Thanks

Phil

Frank Yaeger · Posted: Fri Feb 13, 2009 9:39 pm

Phil,

If the records are already in sorted order by the ON field, you can do a COPY instead of a SORT, e.g,.