Feature Requests item #2875295, was opened at 2009-10-09 03:03 Message generated for change (Settings changed) made by mlkersten You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2875295&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL - general Group: None >Status: Closed Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Nobody/Anonymous (nobody) Summary: SQL: rel_optimizer: apply sum calculation using n-fold mult Initial Comment: The sum of an crossproduct is equal to the sum of the table multiplicated by the amount of joins. Hence we can calculate the sum without doing the actual cross product and summing over the result. ---------------------------------------------------------------------- >Comment By: Martin Kersten (mlkersten) Date: 2009-12-04 11:21 Message: A too specific optimization, which would call for a math reasoner within the SQL front-end. It won't be added in the foreseeable future. ---------------------------------------------------------------------- Comment By: Stefan de Konink (skinkie) Date: 2009-12-01 09:56 Message: What is written in the summary is. But since there was one rewrite option left I didn't close it. ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2009-12-01 09:51 Message: wasn't this optimisation applied? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2875295&group_id=56967 ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
