Re: how to optimize this query
Posted by:
Adrian Nye
Date: March 16, 2009 08:33AM
A couple of related questions about indexes. First, I read that they can be used
for the columns in the where clause so I was wondering if I should have
one for user_id which is in every query. Currently there is only one user with lots of records, but there will eventually be hundreds of users with lots of records.
Second, I assume that MySQL keeps the index(es) up to date, is that correct?
Thanks
Subject
Written By
Posted
Re: how to optimize this query
March 16, 2009 08:33AM
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.