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
0