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 Performance MySQL" what may be of specific interest to you right away is the EXPLAIN function, showing you how MySQL will execute your queries: http://dev.mysql.com/doc/refman/5.0/en/explain.html Dan On 10/16/06, Ahmad Al-Twaijiry <[EMAIL PROTECTED]> wrote:
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 -- Ahmad Fahad AlTwaijiry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]