I have the table and it had 5 columns
CREATE TABLE LIS.LD_EXHIBIT_DESC
AGMT number (10) NOT NULL,
EX VARCHAR2(4000) NOT NULL,
SYSGEN VARCHAR2(1) NULL,
UPDT_DATE DATE NULL,
UP VARCHAR2(12) NULL,
LINE_NO NUMBER(3) NULL
I try to update the column LINE_NO=5 and it takes forever,
the table has about 40K now.
What do I need to to do to speed up this process ???