I have the following table T1, and I wanted to add a new column C4.
CREATE TABLE T1
C1 VARCHAR(50) NOT NULL,
CONSTRAINT PK_T1 PRIMARY KEY(C1)
alter table T1 add column C4 VARCHAR(50);
It seems reorg is not compulsory in this case. But I worry will this affect the performance of select/insert/update/delete on this table if reorg is not done? Or will there be other potential issues?