help wantedsig/executiontype/enhancement
説明
Feature Request
Is your feature request related to a problem? Please describe:
Now the implementation of TiDB's hash-join executor is rough and after profiling, we found there are some issues can be resolved to get better performance:

- not necessary to initialize and reset the
baseJoiner.chkif no condition #14902 - the method
joinMatchedProbeSideRow2Chunkuses the methodNewIterator4Sliceto create a lot of iterators whereas these iterators can be reused. #15423 - some slices created in
GetMatchRowsAndPtrscan be reused. #15423 - we can try to change the return type of
entryStore.getfrom structs to pointers which may reduce memory copy(but it may cause some GC problems so we need some tests after update). - we can try to build the hash table in parallel.
If you have any other ideas, welcome to discuss it with us in our SIG-Exec channel or in this issue by using comments.