👨🎓👨🎓👨🎓 --- An educated guess would be that Microsoft hates you for using Standard Edition, and your batch mode queries are being limited to a DOP of 2. See this post for details on that, and other ways Microsoft intentionally hobbles batch mode in Standard Edition in order to bully you into buying Enterprise Edition licensing. * [How Useful Is Column Store Indexing In SQL Server Standard Edition?](https://erikdarling.com/how-useful-is-column-store-in-standard-edition/)