Re: MyISAM, Select and MoveFirst
Posted by:
Bob Field
Date: July 13, 2006 07:35AM
Anytime you use a LIKE operator where the pattern has an initial wildcard character, a full table scan must be performed to find all matching records. So no index would be of use even if one existed. The variable delay before returning the first record probably has to do with how many rows it had to scan before encounting that particular keyword. The indexes can help to find the matching rows in Table2. The EXPLAIN command can give you more detail on this. I suggest you look into using a FULLTEXT index to improve performance.
Subject
Views
Written By
Posted
4664
July 13, 2006 03:37AM
Re: MyISAM, Select and MoveFirst
2114
July 13, 2006 07:35AM
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.