Using Oracle RDBMS 12.2.
I need to create a table that is going to have VERY frequent INSERTs and DELETEs. It will constantly deleting data more than a few minutes old, and inserting new rows. At any time, I doubt that the table will have more than 10 rows or so.
My first attempt at meeting my requirement, I used an in-memory table defined as an associative array in a package body. Forgot that that is specific to a session - and my users will be creating rows in one session and retrieving them in a separate session.
So is there anything special I should do in my CREATE TABLE to optimize for this? I'm thinking at least that an index organized table would be good.