Skip to content
This repository has been archived by the owner on Jan 5, 2024. It is now read-only.

关于join分析有几个问题 #4

Open
yyyyyogurt opened this issue Apr 15, 2014 · 0 comments
Open

关于join分析有几个问题 #4

yyyyyogurt opened this issue Apr 15, 2014 · 0 comments

Comments

@yyyyyogurt
Copy link

1.在连接执行时,使用的嵌套循环,内部表 和外部表的选择是怎样的呢?一般是小表是外部表,代码中好像没有看到计算表的大小
2.两表连接时,每一次连接都要建立索引,关于COST的3种计算都是基于B树索引?没有HASH索引的执行吗?
3. join中有用到HASH的地方吗?TableFilter中好像没读到
4.题外问题,用您给的代码调试,有很多错误,是因为jdk版本的问题吗?
谢谢!

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant