Re: InnoDB and indexes
Ok, thank you for the answer!
My friends tables didn't have any UNIQUE or NOT NULL columns so InnoDB must have used the internal row ID as key.
He set the timestamp column to be the key and this was apparently as efficient as when InnoDB handled the index.
Do you have any recommendations to letting InnoDB take care of indexes towards using an explicit defined index?
Subject
Views
Written By
Posted
2381
November 02, 2005 02:07AM
1606
November 03, 2005 03:48AM
Re: InnoDB and indexes
1572
November 03, 2005 06:25AM
1410
November 04, 2005 12:05AM
1460
November 04, 2005 06:41AM
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.