How to check whae are tables are having how many indexes on which columns ?
Thomas Sundberg <[EMAIL PROTECTED]> wrote: > -----Original Message----- > From: Seena Blace [mailto:[EMAIL PROTECTED] > Sent: den 11 maj 2005 23:58 > To: mysql@lists.mysql.com > 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