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