Just a couple of questions..
Is the pmp.MANUFACTURE_PROCESS_ID field indexed?
Are the field values equally distributed?
If the answers are (yes, no) and you're using Oracle, maybe you're having a problem with a skewed index.
Is the pmp.MANUFACTURE_PROCESS_ID field indexed?
Are the field values equally distributed?
If the answers are (yes, no) and you're using Oracle, maybe you're having a problem with a skewed index.
Added each "dynamic" line in one by one, and it was ok until I added
pmp.MANUFACTURE_PROCESS_ID back in, then it jumped from 1 sec to many
minutes.
If I run it in TOAD it is fine, 1 sec, the DB definition for this field
is an Integer, its an Integer in the CustomObject class, and the sqlmap
has it as an Integer.
