Article - CS360022
Recommendation about Oracle Database 19c Automatic Indexing in Windchill
Modified: 17-Jan-2022
Applies To
- Windchill PDMLink 11.2 to 12.1
- Oracle Database 19c
Description
- Recommendation about Oracle Database 19c Automatic Indexing
- Oracle database 19c introduced the Automatic Indexing feature, refer too DBMS_AUTO_INDEX and web article
- If Automatic Indexing package is enabled, queries executed similar to:
select /*+ opt_param('_optimizer_use_auto_indexes' 'on') no_parallel_index(t, "STRINGVALUE$XXXX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl opt_param('optimizer_inmemory_aware' 'false') no_substrb_pad no_expand index_ffs(t,"STRINGVALUE$XXXX") */ count(*) as nrw,approx_count_distinct(sys_op_lbid(56868,'L',t.rowid)) as nlb,approx_count_distinct(sys_op_combined_hash("IDA3A6","CLASSNAMEKEYA4","IDA3A5","VALUE","IDA3A4")) as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "WINDCHILL"."STRINGVALUE" t where "IDA3A6" is not null or "CLASSNAMEKEYA4"
is not null or "IDA3A5" is not null or "VALUE" is not null or "IDA3A4" is not null
This is a printer-friendly version of Article 360022 and may be out of date. For the latest version click CS360022