query size
Since I never - until now - worked with real huge tables I have a question on the size of a query. My query would have a maximum result of 600000 lines, but since I might have up to 11 tables in the FROM tag, the cartesian product of which will come easiely up to 10^27.
Is such a query in MySQL possible or will it slow everything down or even blow the server away? What would be a reasonable limit for the cartesian product in the FROM tag?
Subject
Written By
Posted
query size
February 26, 2009 07:13AM
February 26, 2009 07:27AM
February 26, 2009 07:29AM
February 26, 2009 08:41PM
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.