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

Home -> Community -> Usenet -> c.d.o.misc -> Re: to_date function

Re: to_date function

From: Volker Neurath <neanderix_at_gmx.de>
Date: Wed, 19 Dec 2001 21:21:18 +0100
Message-ID: <9vqshv$h3ceh$9@ID-29596.news.dfncis.de> 





Jim Kennedy wrote:



>The problem is that you are forcing a full table scan because you have a

>function on the field. 




Ok - thanks for that hint. I've been using this on a join which
without any restriction gave back about 22,000 records, the last time
i'd run it. Now i know the reason for the long time it took...



Volker
Received on Wed Dec 19 2001 - 14:21:18 CST












Original text of this message













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