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.