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