Re: Why are no indexes used in this case?
Thank you very much Rick!
This particular query used to take 15s in my version for 3 returned records, while your version takes 0.0017s :))
I still think it's a bit strange that my version was so slow, even with proper indexes in place. Maybe some guy from mysql can pick it up and see if it can be optimised.
Thanks again!
Subject
Written By
Posted
February 03, 2013 06:38AM
February 03, 2013 10:27AM
February 03, 2013 11:27AM
February 03, 2013 01:16PM
February 03, 2013 03:35PM
February 03, 2013 04:04PM
February 03, 2013 03:59PM
Re: Why are no indexes used in this case?
February 04, 2013 03:01PM
February 04, 2013 09:11PM
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.