Re: is it normally ?
Posted by:
Jay Pipes
Date: November 06, 2005 06:07PM
Yes, this will be the same for all storage engines, not specific to InnoDB. In the first two test runs, you are forcing MySQL to not use an index (because you have used tyhe RIGHT function and the multiplication of a column in those SQL statements). In the third, the second run completes in 0 seconds because k1 has an index on it (PRIMARY KEY) The other does not, therefore it takes longer. Does that answer your question?
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com
Subject
Views
Written By
Posted
1892
November 05, 2005 03:29PM
Re: is it normally ?
1392
November 06, 2005 06:07PM
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.