MySQL Forums
Forum List  »  Newbie

Index recomendations
Posted by: SreenivasaRao Ponguru
Date: November 09, 2010 07:40AM

Hi all

I have sql statement

FROM tab1
WHERE version='' AND
Rel_date BETWEEN(date_sub(NOW(), interval 1 hour) AND NOW();

I have index on "Version"
above query taking long time to execute

In above query what is best index recomendation ?

Options: ReplyQuote

Written By
Index recomendations
November 09, 2010 07:40AM
November 09, 2010 07:18PM
November 10, 2010 05:56AM

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.