Execution plan compute scala

Question

What actually compute scala in execution plan do ?

Answer 1

Hi @sakuraime ,

What actually compute scala in execution plan do ?

Code as next, it will shows what the compute scalar do in your execution plan:

SET SHOWPLAN_TEXT ON  
GO  

Test on my side, it is used as next:
1.DEFINE:([AdventureWorks2017].[Sales].[SalesOrderHeader].[SalesOrderNumber]=isnull(N'SO'+CONVERT(nvarchar(23),[AdventureWorks2017].[Sales].[SalesOrderHeader].[SalesOrderID],0),N'* ERROR *'))
2.DEFINE:([AdventureWorks2017].[Sales].[SalesOrderHeader].[TotalDue]=isnull([AdventureWorks2017].[Sales].[SalesOrderHeader].[SubTotal]+[AdventureWorks2017].[Sales].[SalesOrderHeader].[TaxAmt]+[AdventureWorks2017].[Sales].[SalesOrderHeader].[Freight],($0.0000)))

You can check on your own side. And then quote from this doc.: sql-server-execution-plan-operators-part-3
SQL Server Compute Scalar operator is used to calculate a new value from the existing row value by performing a scalar computation operation that results a computed value. These Scalar computations includes conversion or concatenation of the scalar value...

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

What is "Scala" ? Is r not working in your keyboard ? You have the answer you are looking for in below link. Hover mouse over the scalar operator and you would see something like [[sod].LineTotal] = Scalar Operator([AdventureWorks2014].[Sales].[SalesOrderDetail].[LineTotal] as [sod].[LineTotal]). This is just example.

why-does-this-execution-plan-have-compute-scalars