From: Shailendra Soni
Date: February 9 2005 1:28pm
Subject: slow query, how can i imporve it?
List-Archive: http://lists.mysql.com/mysql/179623
Message-Id: <828c89a505020905283fb9ed8b@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Hi,

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 
how can i imporve speed of the Mysql or query?

so it will take less time !

Thanks 
Shailendra