Re: MyISAM, Select and MoveFirst
The different response time is due to the limit. It stops once it found the nubmer of rows required. It should be doing a full table scan and has to ignore rows that fail the condition. So, depends to how many rows need to be inspected before it can find 10 rows.
Subject
Views
Written By
Posted
4665
July 13, 2006 03:37AM
2115
July 13, 2006 07:35AM
Re: MyISAM, Select and MoveFirst
1566
July 13, 2006 05:53PM
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.