Database Tuning (MOSC)

MOSC Banner

Memoptimize with RAW(16) datatype?

edited Feb 9, 2020 4:02AM in Database Tuning (MOSC) 4 commentsAnswered ✓

Good morning,

I am trying to test Memoptimize to know improvement using it, and for NUMBER primary key it works properly. I our last data model, primary keys are RAW(16) and it that case, it is not using memoptimize and make INDEX FULL SCAN instead of TABLE ACCESS BY INDEX ROWID READ OPTIM.

Could we use Memoptimize with RAW(16) datatype? Is only available for NUMBER primary keys? What kind of primary keys are enabled for it?

Thanks in advance for your help.

Regards,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center