My thoughts on Oracle Indexes

Create index "DATACORE". "ZZB_1104_INDEX" ON "DATACORE". "ZZB_1104"
(
"DATA_DATE ",
"KMDH ",
"JGDH ",
"HB"
)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE
(
INITIAL 3145728 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 freelist groups 1 BUFFER_POOL DEFAULT
)
TABLESPACE "DATACORE ";

Oracle indexes can indeed improve efficiency the original two-hour batch run task can improve the efficiency of setting a primary key for frequently queried columns by 50%-70%

But how much can be set for initial expansion and next expansion? Data is 30 w

The first test with 655356 has almost no effect.

In the second test, the efficiency was originally 1 hour, 20 minutes, and now only 32 minutes are needed!