SQL Performance (MOSC)

MOSC Banner

Table for temporary data with index and quick insert

Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0

My goal is to set up a cache table that contains indexes and in which inserts are as fast as possible. Since it's a cache table, redo logs aren't useful. I've managed to create a table (without indexes) whose data during an insert is not written to the redo logs, but as soon as an index exists, information is written to the redo logs. Is there any way around this?


Thank you, 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