>How to check whae are tables are having how many
>indexes on which columns ?
and alternatively if you're using 5.03 or later, http://dev.mysql.com/doc/mysql/en/statistics-table.html
eg an approximate equivalent of SHOW KEYS FROM tbl [FROM db] would be
[AND table_schema = 'db']
Seena Blace wrote:
How to check whae are tables are having how many indexes on which columns ?
Thomas Sundberg <firstname.lastname@example.org> wrote:
From: Seena Blace [mailto:email@example.com]
Sent: den 11 maj 2005 23:58
Subject: table optimisation
I have been noticing table performanace issue when # of rows
grows more.How to tune that table?
Adding index on the column or columns that are often used in queries could
be a start. Performing full table scan on large, unindexed tables can take
quite longtime when the number of rows are increasing.
Stay connected, organized, and protected. Take the tour
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 5/10/2005