New Query Transformation Rules In SQL Server 2022

Posted on by Erik Darling

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. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.

Related Posts