MySQL Forums :: MyISAM :: Create indexes on everything?

Advanced Search

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

Subject Views Written By Posted
Create indexes on everything? 1819 fintan guihen 07/29/2014 02:46AM
Re: Create indexes on everything? 985 Rick James 07/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.