MySQL Forums :: Newbie :: Index recomendations


Advanced Search

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

Hi all

I have sql statement

SELECT COUNT(no)
FROM tab1
WHERE version='1.1.1.1' 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


Subject Written By Posted
Index recomendations SreenivasaRao Ponguru 11/09/2010 07:40AM
Re: Index recomendations laptop alias 11/09/2010 07:18PM
Re: Index recomendations SNIVAS P 11/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.