RE: table optimisation

[Thomas Sundberg]

> -----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