Slow "Sending Data" status
Posted by:
Ran Geva
Date: December 19, 2005 03:45PM
Hi,
I have a query:
SELECT a.Var1 FROM list AS a , list AS b WHERE ( a.Var2 = 480 AND b.Var2 = 151 ) AND ( a.Var3 = b.Var3 ) ORDER BY a.Var3 DESC LIMIT 0,100
An EXPLAIN on that query shows that the query execute using the Primary Key and the extra field show "Using where; Using index".
Still it sometime takes up to 60 seconds to receive a result and the query status says:
"Sending Data"
What parameters can I adjust to optimize the "Sending Data" part?
Subject
Views
Written By
Posted
Slow "Sending Data" status
4278
December 19, 2005 03:45PM
2329
December 19, 2005 08:49PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.