database - The impacts of increase column's size in Oracle -
i've script
sql script: alter table xx_vms.es_lot_updates modify (routing_list varchar2(1000)); the previous size of column 255. increase size 1000. in table, routing_list column null. occasionally, has value.
increment size of column make performance issues? i'm confused! please help. thanks.
no, there no performance issue. have done allow bigger text strings inserted in column. keeping in mind should try strict possible want allow in tables, free make columns big need. (max 4000 bytes varchar2)
Comments
Post a Comment