How to tune the query?

kishore Roul

New Member

Join Date: Jan 2011

Posts: 6
#1

How to tune the query?

Jan 21 '11, 06:46 AM

How to tune the query ?
Exp: if query like
select hiredate from emp
where to_char(hiredat e,'dd-mon-yyyy')<'05-05-1982';
Tags: None
amitpatel66

Recognized Expert Top Contributor

Join Date: Mar 2007

Posts: 2358
#2

Jan 21 '11, 09:19 AM

Did you try executing a query? I am sure it will not be having any performance issue.

Can you post an explain plan for the query to check?
Comment

Comment