From: Jay Blanchard Date: February 9 2005 1:40pm Subject: RE: slow query, how can i imporve it? List-Archive: http://lists.mysql.com/mysql/179625 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable [snip] I have a question regarding speed of the query. In my application i am useing Mysql 4.0.20a-nt. I have 10 tables and each table contains 4000000 records and also 61 columns. I already created indexs on six column which are important for me. i fired the query on tables through servlet(thread). I fired same query on all tables on same time, but it has take time to getting result . allmost 7 to 10 minute . so please tell me=20 how can i imporve speed of the Mysql or query? [/snip] Faster hardware and/or more memory.