First - we are not using conversions in indexes, it was just a thought.
Second - that's an idea, but it's that like a conversion anyway?
Thrid - still got same results with your subquery example. Still doing an INDEX scan on cStatus.
I just can't beleive oracle is this stupid to not see that the date range is going to be so much faster.
TIA
Mark
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement