MySQL Forums
Forum List  »  Optimizer & Parser

running running running
Posted by: paolo tome
Date: January 30, 2012 03:16AM

Hello everyone!
I hope that someone wants to share with me a funny query whose behavior is unnerve me for several days.

Link to the query (www.edulink.uniud.it/query.sql) and db with the main tables (www.edulink.uniud.it/diagramma-db.pdf)
the thing that eludes me is why the query stops working (it runs indefinitely without giving results or errors - EXPLAIN also has the same behavior) if there are WHERE conditions among the fields of the last table (t_reperto_micro) .....

anyone can give me some suggestions?

I thank anyone who can help me!

Paolo

Options: ReplyQuote


Subject
Views
Written By
Posted
running running running
2260
January 30, 2012 03:16AM
1259
January 30, 2012 02:39AM
1043
January 30, 2012 09:13AM
1030
January 31, 2012 05:44AM
1135
January 31, 2012 07:54AM
1269
January 31, 2012 03:10AM
1220
January 31, 2012 05:00PM


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.