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