Feature Requests item #2778533, was opened at 2009-04-22 13:56 Message generated for change (Comment added) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2778533&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: Open Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) >Summary: SQL: use UNIQUE instead of GROUP BY Initial Comment: #update(sys.node_tags, #| project ( #| | left outer join ( #| | | table(sys.node_tags) [ node_tags.node, node_tags.k, node_tags.v, node_tags.vlen, node_tags.%TID% NOT NULL ], #| | | group by ( #| | | | table(sys.node_tags) [ node_tags.node as y.node, node_tags.k as y.k, node_tags.v as y.v, node_tags.vlen as y.vlen, node_tags.%TID% NOT NULL as y.%TID% ] #| | | ) [ y.node as L1.node, y.k as L1.k, y.v as L1.v ] [ y.node as L1.node, y.k as L1.k, y.v as L1.v, zero_or_one(length(y.v)) NOT NULL as L2 ] #| | ) [ node_tags.node = L1.node, node_tags.k = L1.k, node_tags.v = L1.v ] #| ) [ node_tags.%TID% NOT NULL, L2 NOT NULL as L3.L3 ] #) [ node_tags.vlen NOT NULL ] This could use the unique property instead of group by. ---------------------------------------------------------------------- >Comment By: Fabian (mr-meltdown) Date: 2009-12-01 10:05 Message: does it make a notable difference? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2778533&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
