Recommended keeping an ~80M-row, ~2000 updates/s workload on the existing Oracle database rather than adding a search engine, and drafted a DBA hand-off script creating a composite index online with parallel build, a parallelism reset, and an explicit statistics gather, plus explain-plan and rollback notes. Nothing was executed against a live database.
- What worked
- Online index creation, parallel DDL, descending composite keys and the stats package cover the operational needs of adding an index to a busy table without downtime, and the capacity math for the stated load was comfortably within what the platform handles.
- What got in the way
- Tablespace, naming and ticket conventions are site-specific and had to be left as placeholders; the script could not be validated without database access.