Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create an index online?

35491Nov 14 2006 — edited Nov 14 2006

Hi, some questions regarding indexes:

I wonder if I can create an index on a table (having 16 million records) online, I mean the table is constantly being used by 50 users doing only inserts all the time. So what happens if I create the index during the table is being used? I'm using Oracle standard edition 9.2.0.6.

I also wonder the difference of using one index on two columns (date, number) or two indexes on the same columns? The queries against this table are always using both columns in the where-clause.

Regards
Carl-Michael

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2006

Added on Nov 14 2006

#general-database-discussions

6 comments

2,973 views