list of cols that I need to index

Hi is there anyway or command to run it against a production table to see if there is any column that I should think about indexing it remember this is a production database, so I can't run it in debug mode and I don't have a root access to the database (I'm just a developer). Thanks --

Re: list of cols that I need to index

Ahmad - It's not always a cut-and-dried thing; performance tuning involves a lot of factors, and with living databases should be an ongoing thing. Check out the section on optimization at http://dev.mysql.com/doc/refman/5.0/en/optimize-overview.html and/or Jeremy Zawodny's excellent book, High