How do "Parallel query processing on partitioned tables and indexes" and "Partitioned table parallelism" differ?
0
votes
1
answer
121
views
In plain English, "Parallel query processing on partitioned tables and indexes" and "Partitioned table parallelism" sound like the same thing. Yet, in SQL Server 2022, [Standard Edition has "Partitioned table parallelism"](https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16#RDBMSSP) but not [Parallel query processing on partitioned tables and indexes](https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16#data-warehouse) . How do the two features differ?
I have made a reasonable effort to search through the documentation, but have not yet read all of the white papers. I have not been successful in learning what either feature is.
Asked by J. Mini
(1237 rep)
Dec 20, 2024, 10:04 PM
Last activity: Dec 22, 2024, 08:48 AM
Last activity: Dec 22, 2024, 08:48 AM