Did you test the statement for so many rows?something wrong?

cloud2001 (坐看云起之山尽水穷)
I tried a table with 33 rows, almost no difference(20 msec--subquery, 40 msec--your statement).
I tried a table with 480184 rows using the sub-query one, it took 35 sec to get back data without index, 23 sec to get back with index, but I tried the one you provided, I waited for at least half an hour, still no data come back, I have to kill the process.
2001-11-14 -04:00
This post has been archived. It cannot be replied.
Page address has been copied. To share, click to copy page address.
Share Online by QR Code

Back To Topic: 闲来无事, 出道ORACLE SQL的题考考大家. 这是在下几个月前工作中遇到的问题, 看似简单, 其实不然.

Back To Forum: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论