avatar
s*i
1
I read that a temp table is always created for
joins, with number of rows equals to the multiple
of all tables. is this true? sounds terrible if
I join two or more tables if the rows are not small...
avatar
c*r
2

It is not true.

【在 s**********i 的大作中提到】
: I read that a temp table is always created for
: joins, with number of rows equals to the multiple
: of all tables. is this true? sounds terrible if
: I join two or more tables if the rows are not small...

avatar
xt
3
It is wrong. That is the mathematical expression of joins,
but it has nothing to do with the real time joins.
avatar
n*m
4
But as know, it temp storage(we call it workfile) did been generated in
non-top level join. Certainly, it is not the representation of the
mathematical expression. Instead, it ususally only contains column/rows
that requried.

【在 xt 的大作中提到】
: It is wrong. That is the mathematical expression of joins,
: but it has nothing to do with the real time joins.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。