Re: Update column takes time!!
Posted by:
Rick James
Date: March 10, 2013 12:08PM
450 is an unusually large number of tables to have.
Indexing every column is almost always useless. In particular, an index on a column that is a 'flag' (true/false value) will almost never be used. Also, MySQL (rarely) uses more than one index in a SELECT.
> Can be a different trick to update a column value, of every table
Rethink how you have designed the need to zero out the column. What does it represent? Can it be stored in a single location, not 450*N places?
Subject
Views
Written By
Posted
1045
March 09, 2013 08:01AM
Re: Update column takes time!!
561
March 10, 2013 12:08PM
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.