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@stripped> wrote:
>
>
>>-----Original Message-----
>>From: Seena Blace [mailto:sqlserverdb@stripped]
>>Sent: den 11 maj 2005 23:58
>>To: mysql@stripped
>>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
>
>
Attachment: [text/html]
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 5/10/2005
