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 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 tables in `index_merge` scan mode. |
Expression/Field compatibility restriction | Parallel query is not supported for SQL statements containing the Generated Column, BIT, or GEOMETRY field. Note: Parallel query is supported for SQL statements containing the BLOB, TEXT, or JSON field when the TXSQL 8.0 engine kernel version is 3.1.14 or later, but the prerequisite is that the runtime value of the txsql_parallel_lob_enabled parameter is set to ON. For the operation method, see Setting Instance Parameters. |
| 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 window functions. |
Was this page helpful?