Home -> Usenet -> c.d.o.tools -> Re: TO_DATE function causes table scan

Re: TO_DATE function causes table scan

From: <dhart_at_t2systems.com>
Date: 30 Mar 2006 12:43:09 -0800
Message-ID: <1143751389.082718.155820_at_z34g2000cwc.googlegroups.com> 






First of all my background is in SQL Server and this is my first time
optimizing an Oracle query.



    
  
  1.   The Entire explain plan is very large... What's parts of it do you
want?
  
  2.   Version 10.1.0
  
  3.   This is a development and I don't think we are. What's the best way
to refresh them.
  
  4.   I tried this the explain plans are the same -- At the moment there
are 3500 rows in the alarm table, how can I force Oracle to use the
index?






Thanks,


Dave
Received on Thu Mar 30 2006 - 22:43:09 CEST












Original text of this message