List:General Discussion« Previous MessageNext Message »
From:Seena Blace Date:May 12 2005 6:40am
Subject:RE: table optimisation
View as plain text  
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.


Yahoo! Mail
 Stay connected, organized, and protected. Take the tour
table optimisationSeena Blace12 May
  • RE: table optimisationThomas Sundberg12 May
  • Re: table optimisationGleb Paharenko12 May
RE: table optimisationSeena Blace12 May
  • Re: table optimisationPeter Brawley12 May