Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL performance tuning
> If you are looking for SO.DT_SO_CMPLT is NULL,
> indexes will not help you on SERV_ORD table (Oracle will not use any indexes).
Sorry,
I mean Oracle should execute full scan SERV_ORD table just your WHERE clause.
Received on Thu Jun 14 2001 - 18:49:20 CDT