Re: 1 Minute to Examine 2907 Rows ?!?!?!?
You have too many CONCAT functions in your WHERE, which skips the index. I am surprised it's managing this SQL in 2.32 seconds, it should take a lot more :)
Firstly, think of doing the string concatenation in your programming language before passing the SQL to MySQL. So if you use PHP, compose the comparison first and then compose your SQL dynamically.
Secondly, do you have indexes on all those columns in your WHERE clause?
HTH.
Subject
Views
Written By
Posted
2151
June 03, 2005 11:13AM
1428
June 03, 2005 11:52AM
Re: 1 Minute to Examine 2907 Rows ?!?!?!?
1353
June 04, 2005 02:35AM
1489
June 06, 2005 03:02PM
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.