New Query Transformation Rules In SQL Server 2022

Brand New


Here are new lines from the query transformation stats view in SQL Server 2022:

+--------------------------------+
|              name              |
+--------------------------------+
| BuildDataExportPut             |
| BuildRemotePut                 |
| EnforceDistribution            |
| FetchXcs                       |
| GetToFetchXcs                  |
| ImplementDistribution          |
| ImplementGlobalSequenceProject |
| ImplementLocalSequenceProject  |
| LASJIsNullToDist               |
| LSJIsNullToDist                |
| MatchGbJoin                    |
| MatchGbNAryJoin                |
| PushImpliedIsNotNull           |
| RemoveSubqInCube               |
| RemoveSubqInRollup             |
| RemoveSubqInTFP                |
| SelectToFilteredExternalGet    |
| SelGetToFetchXcs               |
| SelInToJoinGb                  |
+--------------------------------+

Thanks for reading!

Going Further


If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.