Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Many indexes on a large table
I have a table with:
This table is part of a product, so the design is not open to change (at
least in the short run).
At one stage in the batch-process of building this table, 20 indexes are
created.
This is done in a very simple way... by issuing 20 CREATE INDEX
statements.
Each takes a little under an hour to complete, with 15 hours to create all
20 indexes.
Questions:
Thanks
Walter [Please post replies to the newsgroup] Received on Wed May 29 2002 - 20:15:39 CDT
![]() |
![]() |