Enhance Show Plan to Distinguish Scalar & Vector Aggregates - by Paul White NZ

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


7
0
Sign in
to vote
ID 730458 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 3/11/2012 9:49:24 AM
Access Restriction Public

Description

It would be useful to be able to determine whether an aggregate in a query plan is computing a scalar or vector aggregate - particularly when a GROUP BY clause has been simplified away by the optimizer.  Not having this distinction makes some query plan issues hard to identify and resolve, particularly where the aggregate appears in a correlation or is a CLR aggregate.

Simple example:  Current show plan output does not give us a way to distinguish between:

-- Scalar
SELECT COUNT_BIG(*)
FROM Production.TransactionHistory AS th 
WHERE th.ProductID = 709;

-- Vector, GROUP BY simplified away
SELECT COUNT_BIG(*)
FROM Production.TransactionHistory AS th 
WHERE th.ProductID = 709
GROUP BY th.ProductID;
Sign in to post a comment.
Posted by Microsoft on 3/16/2012 at 11:31 AM
Hello Paul,

Thank you for the suggestion regarding show plan. We'll consider it for a future release.

Susan Price
Senior Program Manager
SQL Server Database Engine