MVSFORUMS.com

drammo · Beginner Joined: 13 Jan 2006 Posts: 20 Topics: 10

I am LOADing data in to a table with no unique indices. However 3 non-unique indices are created on it. Will it help to sort the input dataset on one of these non-unique indices (the one which is most likely be used)?

Thanks!

Manas Biswal · Posted: Tue Jan 31, 2006 9:54 am Post subject:

drammo,

I would think so. Yes.

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

schintala · Posted: Tue Jan 31, 2006 3:20 pm Post subject:

It really doesn't matter whether you have unique or non unique indexes in the table. During load utility, sort is one of the phase which runs after reload phase.

Manas Biswal · Posted: Wed Feb 01, 2006 10:08 am Post subject:

schintala,

The SORT phase runs after the RELOAD phase only if you let it run. If drammo wants to run a load with the records sorted on one particular (frequently used) index, it would be a better idea to sort the input file before loading it.
If we drop all the indexes other than the one on which you want the records sorted, and load the input file(already sorted on the one remaining index), DB2 load will skip the SORT phase after the RELOAD phase.
After the load, you will have all the records sorted on the index you want. You can then create the remaining indexes that you had dropped before the load.

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)