Alter or modify length columns affect to indexes and degrade the performance?
Hello,
1) I would like to know if the performance of queries degrade doing this modifications on the indexes columns:
- resize columns number(10) to number without precision
- resize columns varchar2(10) to varchar2(100)
- resize columns with char
- change columns not null to null
2) I have to rebuild or drop and recreate the indexes?
0