索引操作

create index idx_fa_ledger_h_001 on fiefa.fa_ledger_h(accentity_id,accbook_id,asset_code);

analyze table  iuap_apdoc_basedoc.bd_staff
ALTER table fiefa.fa_ledger_h alter INDEX idx_fa_ledger_h_001 inVISIBLE
ALTER table fiefa.fa_ledger_h alter INDEX idx_fa_ledger_h_001 VISIBLE
ALTER table fiefa.fa_ledger_h drop INDEX idx_fa_ledger_h_001

--强制索引

SELECT id FROM iuap_apdoc_basedoc.bd_staff force index(idx_bd_staff_001 WHERE user_id = '1257e559-6a82-4309-bc9c-a4025e66d403'