Searching on HZ_ORGANIZATION_PROFILES_

Hi all

we need to create a report, to run weekly, that searches for Accounts/Organizations on which a specific field changed in the last week.

Any idea how to avoid a FULL TABLE SCAN? do we need to create an index on CREATION_DATE of table HZ_ORGANIZATION_PROFILES_?

Otherwise, any other approach?

many thanks, Luca