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

Home -> Community -> Usenet -> c.d.o.server -> Re: PB with performance request

Re: PB with performance request

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 31 May 2006 20:48:58 GMT
Message-ID: <_infg.115408$F_3.31684@newssvr29.news.prodigy.net> 





ianal Vista wrote:



> I suspect implicit variable conversion which precludes use of index

> 

> Post the results from 

> SQL> DESC DVACCPER.ACNTYY 


> 




    
  
  1.   What makes you think there is an index on that column?
  
  2.   What do you think will happen when you ask oracle to describe a
    column?





-- 
Mladen Gogala
http://www.mgogala.com


Received on Wed May 31 2006 - 15:48:58 CDT












Original text of this message













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