Re[2]: SQL Tuning - How to avoid TOCHAR function against a date
How about something like: SELECT DATE_KEY FROM DATE_DIM WHERE ORACLE_DATE between trunc(:b1) and trunc(:b1)+86399/86400; It's not the prettiest thing in the world, but it keeps the use of the index on ORACLE_DATE and an adjacent comment that there are 86400 seconds in the day should make it
Re: Re[2]: SQL Tuning - How to avoid TOCHAR function against a date
Bob, Thanks for your reply. I am testing this afternoon. Cherie Robert