How to get the latest Records from Table

Hi Experts,

We are querying on a table CDPOS(Change Log). Our query requiredment is to get the latest change record for any sales Order / Customer / etc from CDPOS table.

Could some one please guide me how can I get this done in HANA?

As of i know i could sort the table based on Time stamp and get the latest record. But this is a cost effective as the table contains huge amount of data.

Please suggest if any other alternative.

Best regards,

Krishna.