MySQL Forums
Forum List  »  Newbie

Re: Query in a loop
Posted by: Rick James
Date: January 20, 2009 10:49PM

ALTER TABLE articles
  ADD INDEX (category_id, views);
Doesn't do what you _explicitly_ asked for, but may do what you _implicitly_ asked for, namely a speedup.

Options: ReplyQuote


Subject
Written By
Posted
January 20, 2009 08:54AM
Re: Query in a loop
January 20, 2009 10:49PM


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.