MySQL Forums
Forum List  »  MyISAM

Create indexes on everything?
Posted by: fintan guihen
Date: July 29, 2014 02:46AM

Im currently learning the intracicies of mySQL. One book states that myISAM has no buffer pool for data, but does have one for indexes.

My question is:

When using myISAM, does it make sense to have at least one index on every table that includes all columns?

Im aware how naieve this sounds, but im just trying to figure out how this could be made as performant as possible.

Options: ReplyQuote

Written By
Create indexes on everything?
July 29, 2014 02:46AM
July 30, 2014 10:22PM

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.