MySQL Forums
Forum List  »  Optimizer & Parser

Query Optimization
Posted by: Alessandro De Lorenzi
Date: May 18, 2010 07:43AM

Hi, i have this query that is runnig very very slow:

UPDATE temp_result_table trt
SET trt.source_word = (SELECT es.word FROM english_synset es WHERE es.id = trt.id_source_word)
WHERE trt.source_word IS NULL;

temp_result_table contains about 25 rows, english_synset contains 100000 rows.
the filed id is the primary key of the english_synset table, tmp_result_table does not have any index (it is a temporary table)

Does anyone have ideas on how to speed up my query? Or can anyone suggest me some tool to check the execution plan tht mysql is executing?
Regards

Options: ReplyQuote


Subject
Views
Written By
Posted
Query Optimization
3108
May 18, 2010 07:43AM
1520
May 20, 2010 09:19PM


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.