Is there a more performant way to enhance the following SQL syntax on Oracle, theres around 400million records in a table, but is taking 30 seconds to execute. iTrackingLogId
is an index
select max(iTrackingLogId), max(tsLog) from NmsTrackingLogRcp where TRUNC(tsLog) = TRUNC(CURRENT_DATE)