MySQL Forums :: MyISAM :: Create indexes on everything?
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.
Sorry, only registered users may post in this forum.
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.