The name of the table in the hint (c) doesn't match
any table from the from clause (cliemp) .
Change the from clause to
from cliemp c
HTH
- Marcos.Vera_at_msconsultores.com.pe a icrit : >
>
>
>
> hi gurus ...
>
> does anyone know why this
>
> EXPLAIN PLAN
> FOR
> SELECT /*+ FULL ( c ) */ field2, field3 FROM
> cliemp
> WHERE emp_ide_emp >'10004918' ;
>
> get ....
>
> EXECUTION PLAN
> ================
> SELECT STATEMENT COST = 10
> TABLE ACCESS BY INDEX ROWID CLIEMP
> INDEX RANGE SCAN IK_02_CLIEMP
>
> ????????????????????????????????
>
> thanks gurus ...
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Marcos.Vera_at_msconsultores.com.pe
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place.
Received on Wed Nov 08 2000 - 07:11:24 CST