SS (BY INDEX ROWID) OF 'ILSRONODALREQUEST'
0 INDEX (UNIQUE SCAN) OF 'IX_ILSRONODALREQUEST' (UNIQUE)
Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, November 12, 2002 4:39 PM
To: Multipl
Bill,
Without seeing the explain plans, I'll take a shot. I hope it makes
sense...
1 assumption, which if incorrect invalidates everything. I assume
that there is not an index on table2.objid.
I think the issue is how statement 1 is executed. Since the subquery
is not-correl
e recipients of list ORACLE-L
<[EMAIL PROTECTED]>
(Bill), cc:
ALCAS"