Searching on HZ_ORGANIZATION_PROFILES_ — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!