Sunday, 15 September 2013

how can I reduce query execution time?

how can I reduce query execution time?

I have some insert, update, merge statements which are dealing with
billions of rows.
So if there is single update statement, it takes too much time to update
the table.
is there any technique in oracle to reduce this time
like in insert statement I just want to insert first 100 rows, afterwords
it should stop execution.
thanks in advance for your help..!

No comments:

Post a Comment