MySQL Forums
Forum List  »  InnoDB

Re: Slow Performance / Index not used
Posted by: Horst Pralow
Date: August 29, 2008 03:43AM

Rick James Wrote:
-------------------------------------------------------
> In InnoDB (not MyISAM), the data is stored on disk
> in PRIMARY KEY order. There is no separate
> "index". So, in order to walk thru the PK, it has
> to do a table scan.
>

Thats interesting. Does that mean use of the primary key always results in full table scans? If so PK usage e.g. for joins should be avoided?
Or, in other words: The PK should be considered for InnoDB's private usage (e.g. for row locking tec) and should not be used in any query?

Is that a corrcet conclusion?

Options: ReplyQuote


Subject
Views
Written By
Posted
2802
August 28, 2008 08:46AM
1760
August 28, 2008 11:12PM
Re: Slow Performance / Index not used
1816
August 29, 2008 03:43AM
1657
August 30, 2008 12:31AM


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.