MySQL Forums
Forum List  »  Optimizer & Parser

Re: How to optimize this query
Posted by: Apachez
Date: May 13, 2006 08:22AM

I assume that the columntype of id_pr_data_feed is something like "unsigned int" or similar ?

If so, numeric that is, then its incorrect to wrap the value around '.

What happends is that mysql is forced to cast all values into stringtype before they then can be evaluated.

So if you change your "WHERE id_pr_data_feed='49'" into "WHERE id_pr_data_feed=49" I think you query will be blazing fast...

Options: ReplyQuote


Subject
Views
Written By
Posted
2441
May 13, 2006 04:36AM
Re: How to optimize this query
1881
May 13, 2006 08:22AM


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.