Re: Index creation ased on Select statement
I'm not aware of any specific software that would do that but enabling slow-query-log and making use the EXPLAIN should give a good hint on where you may want to add indexes.
Adding indexes helps on most cases (SELECT cases), unless you have many insert statements (more indexes increase the time on inserts)
I hope this helps.
Diego Medina
Web Developer
http://www.fmpwizard.com
P.S. Please read
this post if you are going to post code
Subject
Written By
Posted
September 27, 2007 05:02PM
Re: Index creation ased on Select statement
October 09, 2007 12:38PM
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.