diff options
| author | Monty <monty@mariadb.org> | 2022-06-30 15:43:58 +0300 |
|---|---|---|
| committer | Sergei Petrunia <sergey@mariadb.com> | 2023-02-02 22:58:52 +0300 |
| commit | 07df2029a371de84b68dcfa8c29bac52ab29aa45 (patch) | |
| tree | be0d7d2a2ac1bb57a1a7c2b1849c5278c8a892ba /mysql-test/main/subselect4.result | |
| parent | 4515a89814adaa61b26a900086a54b8cf51f188a (diff) | |
| download | mariadb-git-07df2029a371de84b68dcfa8c29bac52ab29aa45.tar.gz | |
Adjust cost for re-creating a row from the JOIN CACHE
Creating a record from the join cache is faster than getting a row from
the engine (less and simpler code to execute).
Added JOIN_CACHE_ROW_COPY_COST_FACTOR (0.5 for now) as the factor to
take this into account. This is multiplied with ROW_COPY_COST.
Other things:
- Added cost of copying rows to hash join, similar to join_cache joins.
Diffstat (limited to 'mysql-test/main/subselect4.result')
| -rw-r--r-- | mysql-test/main/subselect4.result | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/mysql-test/main/subselect4.result b/mysql-test/main/subselect4.result index b6672e44915..48fe29344a5 100644 --- a/mysql-test/main/subselect4.result +++ b/mysql-test/main/subselect4.result @@ -1277,10 +1277,9 @@ EXPLAIN SELECT * FROM (t2 LEFT JOIN t1 ON t1.c1) LEFT JOIN t3 on t3.c1 WHERE 's' IN (SELECT c1 FROM t2); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 system NULL NULL NULL NULL 0 Const row not found -1 PRIMARY t2 ALL NULL NULL NULL NULL 3 -1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 4 func 1 +1 PRIMARY t2 ALL NULL NULL NULL NULL 3 Using where; Start temporary; End temporary +1 PRIMARY t2 ALL NULL NULL NULL NULL 3 Using join buffer (flat, BNL join) 1 PRIMARY t3 ALL NULL NULL NULL NULL 3 Using where -2 MATERIALIZED t2 ALL NULL NULL NULL NULL 3 Using where SELECT * FROM (t2 LEFT JOIN t1 ON t1.c1) LEFT JOIN t3 on t3.c1 WHERE 's' IN (SELECT c1 FROM t2); c1 c1 c1 EXPLAIN |