This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / How come the join is so slow in microsoft access database? It's such a simple join. Thanks.
-tongcd(Rock Your Body);
2005-1-12
{661}
(#2070711@0)
-
do u have index(uniqe, non-uniq) on defects.defctnum, custmval.idderec, and defects.idrecord?BTW, my 2 cents, the second query may have better performance, if the DB engine doesn't have ablility to convert the sub-query to inner join.
use sub-query unless u must use "exist, in", otherwise use sub-query instead. Just for better performace.
Above is all based on database general sense. I don't use M$ DB at all.
-647i(盲人协会);
2005-1-12
{330}
(#2070725@0)
-
Thanks for prompt reply. I was wrong about using access, actually I was just using linking to table via odbc from access. So it must be something wrong with odbc driver I was using.
-tongcd(Rock Your Body);
2005-1-12
(#2070790@0)
-
看了半天才看懂:prompt -> hints,trick. 你以为我是机器呀，给你prompt.
-647i(盲人协会);
2005-1-12
(#2071749@0)