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
