MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Performance Problem - how to tune a query?
Posted by: KimSeong Loh
Date: November 01, 2005 08:01PM

You are having almost a Cartesian product, with no join column.
The query is not only slow, it could also give you the wrong result.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Performance Problem - how to tune a query?
3084
Daniel Fricke
October 31, 2005 08:38AM
Re: Performance Problem - how to tune a query?
1395
HubbleSpace
October 31, 2005 09:04AM
Re: Performance Problem - how to tune a query?
1343
KimSeong Loh
November 01, 2005 08:01PM
Cartesian product - wrong result
1369
HubbleSpace
November 02, 2005 01:42AM
Re: Cartesian product - wrong result
1377
KimSeong Loh
November 03, 2005 08:10PM


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.