Full table scans with Date fields

[Quoted] [Quoted] We have a financial system that that is heavily date-dependent. All calcs, queries, imports, database triggers, etc are date-dependent.

[Quoted] The problem is that we only reference the date portion of the date and not the time. To do this, the entire system uses the TRUNC(DATE) function and this causes full table scans in every imaginable situation, therefore, the performance is horrible in nearly every aspect.

I have implemented the BETWEEN condition in place of the ' = TRUNC(DATE)' in many of my IF statements to utilize indexes, but this is not feasible for database triggers and a few other situations.

It's hard for me to believe there isn't another way. Does anyone have any suggestions?
Please email me, as our newsgroup server is unreliable.

THANKS! Received on Thu May 22 1997 - 00:00:00 CEST