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 on 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.