Re: Update Speed problem
Posted by:
Rick James
Date: April 02, 2009 12:43AM
Sounds like update_category needs
INDEX (sku)
Without that, it has to do about 4.9 billion (700K*700K) operations. Don't even think about how much work it would take with 10M rows!
Actually, it would probably run faster if update_category had
INDEX (sku, category)
Then it only needs to look in the index.
Subject
Written By
Posted
Re: Update Speed problem
April 02, 2009 12:43AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.