Index recomendations
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 ?
Subject
Written By
Posted
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.