1. 修改主键自增长的初始值

--获取最大的id值    select max(tel_id) from tm_contact_tel    --修改初始值    ALTER TABLE ACCOUNT ALTER COLUMN ACCOUNTID RESTART WITH 1104

2. 修改主键为自增长

Alter table 
    
      set generated always as identity
    
    
      alter  

3.创建索引

CREATE INDEX "CTS"."TM_COLL_UINT_HIST_INDEX"ON    "CTS"."TM_COLL_UNIT_HIST"    (        "CUST_ID"    );