Re[2]: SQL Tuning - How to avoid TOCHAR function against a date

2002-04-08 Thread Robert Eskridge
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

2002-04-08 Thread Cherie_Machler
Bob, Thanks for your reply. I am testing this afternoon. Cherie Robert