SF
is 100
and Dop
is 16
, the acceleration ratio is as follows.SELECT l_returnflag, l_linestatus,Sum(l_quantity) AS sum_qty,Sum(l_extendedprice) AS sum_base_price,Sum(l_extendedprice * (1 - l_discount)) AS sum_disc_price,Sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS sum_charge,Avg(l_quantity) AS avg_qty,Avg(l_extendedprice) AS avg_price,Avg(l_discount) AS avg_disc,Count(*) AS count_order FROMlineitem WHERE l_shipdate <= date '1998-12-01' - INTERVAL '93' dayGROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus ;
SELECT l_returnflag, l_linestatus,Sum(l_quantity) AS sum_qty,Sum(l_extendedprice) AS sum_base_price,Sum(l_extendedprice * (1 - l_discount)) AS sum_disc_price,Sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS sum_charge,Avg(l_quantity) AS avg_qty,Avg(l_extendedprice) AS avg_price,Avg(l_discount) AS avg_disc,Count(*) AS count_order FROMlineitem WHERE l_shipdate <= date '1998-12-01' - INTERVAL '93' dayGROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus ;
selectsum(l_extendedprice* (1 - l_discount)) as revenuefromlineitem,partwhere(p_partkey = l_partkeyand p_brand = 'Brand#12'and p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')and l_quantity >= 6and l_quantity <= 6 + 10and p_size between 1 and 5and l_shipmode in ('AIR', 'AIR REG')and l_shipinstruct = 'DELIVER IN PERSON')or(p_partkey = l_partkeyand p_brand = 'Brand#13'and p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')and l_quantity >= 10 and l_quantity <= 10 + 10and p_size between 1 and 10and l_shipmode in ('AIR', 'AIR REG')and l_shipinstruct = 'DELIVER IN PERSON')or(p_partkey = l_partkeyand p_brand = 'Brand#24'and p_container in ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG')and l_quantity >= 21and l_quantity <= 21 + 10and p_size between 1 and 15and l_shipmode in ('AIR', 'AIR REG')and l_shipinstruct = 'DELIVER IN PERSON');
Restriction | Description |
Statement compatibility restriction | Parallel query is not supported for non-query statements, including INSERT ... SELECT and REPLACE ... SELECT. |
| Parallel query is not supported for statements in a stored program. |
| Parallel query is not supported for prepared statements. |
| Parallel query is not supported for statements in serial isolation-level transactions. |
| Parallel query is not supported for locking reads, such as SELECT FOR UPDATE and SELECT ... FOR SHARE. |
| Parallel query is not supported for CTEs. |
Table/Index compatibility restriction | Parallel query is not supported for system, temp, and non-InnoDB tables. |
| Parallel query is not supported for space index. |
| Parallel query is not supported for full-text index. |
| Parallel query is not supported for partitioned tables. |
| Parallel query is not supported for tables in `index_merge` scan mode. |
Expression/Field compatibility restriction | Parallel query is not supported for tables containing generated columns or BLOB, TEXT, JSON, BIT, and GEOMETRY fields. |
| Parallel query is not supported for aggregate functions of the BIT_AND, BIT_OR, or BIT_XOR type. |
| Parallel query is not supported for DISTINCT aggregations, such as SUM(DISTINCT) and COUNT(DISTINCT). |
| Parallel query is not supported for GIS functions such as SP_WITHIN_FUNC and ST_DISTANCE. |
| Parallel query is not supported for custom functions. |
| Parallel query is not supported for JSON functions such as JSON_LENGTH, JSON_TYPE, and JSON_ARRAYAGG. |
| Parallel query is not supported for XML functions such as XML_STR. |
| Parallel query is not supported for user-lock functions such as IS_FREE_LOCK, IS_USED_LOCK, RELEASE_LOCK, RELEASE_ALL_LOCKS, and GET_LOCK. |
| Parallel query is not supported for SLEEP, RANDOM, GROUP_CONCAT, SET_USER_VAR, and WEIGHT_STRING functions. |
| Parallel query is not supported for certain statistical functions such as STD, STDDEV, STDDEV_POP, VARIANCE, VAR_POP, and VAR_SAMP. |
| Parallel query is not supported for subqueries. |
| Parallel query is not supported for window functions. |
| Parallel query is not supported for ROLLUP. |
Was this page helpful?