Hello everyone,
I’m running into severe performance issues while creating indexes and would appreciate any practical advice.
Context
- What I’m doing: Creating 89 indexes via
EXECUTE IMMEDIATE in a single script/run.
- Data size: 8 different tables, each with ~1.5 billion rows.
- Problem: Each index is taking a very long time to build; the overall process is extremely slow.
The question: Is there some way to resolve this problem?
If anyone has successfully optimized bulk index creation on tables of this scale, please share commands, parameters, and caveats that worked for you.
Obs.: I'am using sql developer 11c version