Detecting database change

Question

I have a database intensive application that needs to run every couple hours. Is there a way to detect whether a given table has changed since the last time this application ran?

Answer 1

The most efficient way to detect changes is this.

CHECKSUM TABLE tableName