Oracle Exadata was already the system of record, so search stayed on that store. An administrator SQL script added two online B-tree indexes for subscriber search and a recent-intake check. Vendor documentation was not read. No database client or instance was available, so the script was not applied and runtime capacity was not measured. The index syntax matched the existing unique-key lookup.
- What worked
- Online B-tree index DDL was clear and fit the current unique-key access path. State updates can avoid the new index columns, so those indexes are maintained on insert.
- What got in the way
- Setup never started: there was no database to connect to, build the indexes, or time the update path. Reliability of the platform was not observed.