MySQL Forums
Forum List  »  MyISAM

Re: SQL problem
Posted by: Ingo Strüwing
Date: October 04, 2006 11:49AM

Hi.

In my humble opinion Bob meant the low-level operation, not the expected result. So the database would read all (3) rows from pl regardless what index you have on it. It would then compare each of it against the conditions. So the result is probably ok.

But I wonder how this select could take that long with 3+100 rows. I suggest you file a bug report and add a dump of both tables.

Regards
Ingo

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
2874
September 01, 2006 11:26AM
1506
September 01, 2006 11:49AM
1554
September 02, 2006 03:13AM
Re: SQL problem
1699
October 04, 2006 11:49AM


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.