Skip to Main Content

General Development Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

index assistance

Jeff RothMar 7 2024

I have a query with this as the filter predicate:

TRUNC(INTERNAL_FUNCTION("FACT_TABLE"."FDATE"))=TO_DATE(' 2024-03-05 00:00:00', 'syyyy-mm-dd hh24:mi:ss')

The PK is on FDATE and we scan the entire table.

What would you suggest for an index strategy for the filter? I'm a MSSQL DBA so I am not certain of all that is available in Oracle. I'm guessing the function is making the filter non-SARGable.

I don't think my company would appreciate me posting the plan or table structure.

Thanks for any insight. Sorry if I posted in the wrong area.

Comments
Post Details
Added on Mar 7 2024
3 comments
55 views