[MDEV-20440] Optimizer trace: print more details about semi-join optimization Created: 2019-08-28  Updated: 2019-09-12  Resolved: 2019-08-28

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Fix Version/s: 10.4.8

Type: Task Priority: Major
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-6111 optimizer trace Closed

 Description   

This is to track this improvement
http://lists.askmonty.org/pipermail/commits/2019-August/013945.html

revision-id: 31815d37666d3ca9fae2df45b99138e1c4507bab (mariadb-10.4.7-33-g31815d37666)
 
parent(s): efb8485d85b19a2a729310adc6779ca649198f29
 
author: Sergei Petrunia
 
committer: Sergei Petrunia
 
timestamp: 2019-08-25 11:03:19 +0300
 
message:
 
 
 
MDEV-6111: Optimizer Trace: add tracing for semi-join optimizations
 
 
 
Added:
 
- "semijoin_strategy_choice" element (actions in advance_sj_state(), name
 
  matches the name in MySQL)
 
 
 
- semijoin_table_pullout element.



 Comments   
Comment by Varun Gupta (Inactive) [ 2019-09-01 ]

Added a followup fix for this
https://github.com/mariadb/server/commit/29b13d114e4c4a8a880ddf052351f7bfdc5e1fa3

Generated at Thu Feb 08 08:59:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.