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.

/Thomas



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