CODEWITHSUNDEEP
oracle-databaseindexing
Asad Iqbal
Asad Iqbal

Reputation: 3321

Oracle: does increasing column size affect the index in any way

I have a table which is being used in production for years and has tons of data in it. If i increase the columns size of an indexed column, will I have to rebuild the indexes?

Upvotes: 1

Views: 3929

Answers (2)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60262

If you're talking about a VARCHAR2 column, increasing the maximum length does not affect existing data, ergo will not affect your index either.

Upvotes: 2

Zzz
Zzz

Reputation: 3025

An index contains columns with data and rowid for each row of the table. So if you increase the length of indexed column, the existing indexes will not be impacted.

Upvotes: 1

Related Questions