Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Add new column with index on it on very large table

reddy1234Jul 25 2023

Database version : 19.15.1.0.0 (Enterprise Edition)

I have a table with 12 billion rows in it, I have to add a column and create an index on the new column.

New column allows Null value for the existing records, we will consider populating going forward for the new column.

for existing 12 billion rows this column value is Null, is there a faster way to create index for this column?

Comments

Post Details

Added on Jul 25 2023
#column, #general-database-discussions, #index, #table
4 comments
466 views