Re: Tunning or optimizing a query
Well, the important things to look at are possible_keys, key, and rows. possible_keys will have any indexes that could be used for a given table. key will be the one it uses. rows will be the number of rows it has after completing it's query against that table. If you want a good book, I would recommend the MySQL Administrator's Guide from MySQL Press - it's a wonderful reference.
Subject
Written By
Posted
Re: Tunning or optimizing a query
April 05, 2005 02:15PM
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.