| sql developer vs toad, indexing [message #437501] |
Mon, 04 January 2010 15:26  |
namitanamburi
Messages: 35
Registered: March 2009
|
Member |
|
|
Hi all,
There is a table EMP and has few fields like date, amount etc on which Iam querying as below
select * from EMP where trunc(date) = to_date('01/01/2009','mm/dd/yyyy')
When I do the explain plan in toad , it shows a full table scan.
There is an function based index on date field with column expression as trunc("date").
When I run same query in Toad, it doesn't do a full table scan instead a index based query .
Does sql developer expect a query like this?
select * from EMP where trunc("date") = to_date('01/01/2009','mm/dd/yyyy')
what is the right way of querying when the index is as above?
Any clue what the issue is?
Thanks
Nammu
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
