Create indexes on everything?
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.
Subject
Views
Written By
Posted
Create indexes on everything?
2590
July 29, 2014 02:46AM
1547
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.