Hi :
We need some guidance on some query which does Insert by select from some tables.
It works fine lets say for 50,000 but once we start 60,000 it is taking for ever.

but if we do in smal subsets it works fine.

Can someone put light on this ,that why it is happening?

any idea?

Environments:

UDB 8.2.2

AIX 5.2

We have upto date statistics on all the tables.

Thanks and appreciate in advance for any guidance.

-

You may be running out of log space, but in that case the statement should rollback with an error.

oraora, can you please provide error message, SQL sintax, table definitions of source and target table.