RE: Performance tuning

If using the hint FULL ( c )
you should give the table an alias named c :

explain plan for
select /*+ FULL (c) */ field2, field3 from cliemp c where emp_ide_emp > '10004918' ;

When not using the alias, stat /*+ full (cliemp) */ as hint

Hope this helps !

> -----Original Message-----
> From: Marcos.Vera_at_msconsultores.com.pe
> [SMTP:Marcos.Vera_at_msconsultores.com.pe]
> Sent: Wednesday, November 08, 2000 7:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Performance tuning
>
>
>
>
>
> 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).
Received on Wed Nov 08 2000 - 01:24:52 CST