Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Performance tuning

RE: Performance tuning

From: <Marcos.Vera_at_msconsultores.com.pe>
Date: Wed, 8 Nov 2000 01:28:17 -0500
Message-Id: <10673.121390@fatcity.com> 





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 ...
Received on Wed Nov 08 2000 - 00:28:17 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US