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.
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.
>
>
|