same results, but one takes longer
From: Mike Lim <mlim_at_ibx.com>
Date: Wed, 17 Mar 93 19:40:47 GMT
Message-ID: <1993Mar17.194047.3233_at_ibx.com>
Date: Wed, 17 Mar 93 19:40:47 GMT
Message-ID: <1993Mar17.194047.3233_at_ibx.com>
The following two nested select statements give the same results. However, one (i.e. statment 1) takes much less time to process than the other:
SQL statement 1:
SQL statement 2:
Assumptions at time of observation:
Oracle v6.
System's table has approx. 481 records
Configuration's table has approx 1900 records
Sysuser's table has approx. 242 records
Thanks in advance.
- LIM -- mlim_at_ibx.com 215-241-4472