Seena,

>How to check whae are tables are having how many
>indexes on which columns ?

http://dev.mysql.com/doc/mysql/en/show-index.html

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
SELECT *
FROM information_schema.statistics
WHERE table_name='tbl'
[AND table_schema = 'db']

PB

-----

Seena Blace wrote:

How to check whae are tables are having how many indexes on which columns ?

Thomas Sundberg <thomas.sundberg@gamefederation.com> wrote:

-----Original Message-----
From: Seena Blace [mailto:sqlserverdb@yahoo.com] 
Sent: den 11 maj 2005 23:58
To: mysql@lists.mysql.com
Subject: table optimisation

Hi,
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.

/Thomas



		
---------------------------------
Yahoo! Mail
 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