two functions versus one maybe
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: woensdag 5 maart 2003 7:34
To: Multiple recipients of list ORACLE-L
Subject: Slow query


Dear all,

Please find below the 2 queries :

select dep_date from test_date1
where to_char(dep_date,'dd-mon-yyyy') = '12-jan-2002'

select dep_date from test_date1
where TRUNC(dep_date) = to_DATE( '12-jan-2002','dd-mon-yyyy')

The execution plan for both the queries shows a FTS on test_date1.

Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE
   1    0   SORT (AGGREGATE)
   2    1     TABLE ACCESS (FULL) OF 'TEST_DATE1'

The number of rows to be retrieved are 120010.

The first query took 10msec to execute whereas the second took about 2 secs.

Could anyone help me figure out what the problem would be.

TIA


Best Regards
Jai

Reply via email to