SAP Note 101636 - 4.0/ Oracle: Full Table Scans, Cost-Based Optimizer

Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/101636 (SAP Service marketplace login required)

Key words :
rsdb/max_blocking_factor      =-1rsdb/min_blocking_factor      =-1rsdb/max_in_blocking_factor   =-1rsdb/min_in_blocking_factor   =-1default, cost-based optimizer evaluates full table scans, analyze table <table_name> compute statistics, additional key words performance, prerequisites unlike earlier releases, full table scan lower, full table scan, rsdb/max_blocking_factor, cost-based optimizer, rule-based optimizer

Related Notes :

321345Long runtimes in FORM EINB_MLST_COPY (FCJWBFKP)
303140Techn.object: performance problem f.structure lists
200228Performance problems in PS under Oracle
135254Perfrmance problems in Projct System as of Rel. 4.0
134846GET_PS_OBJECTNUMBER: Long runtime
132901Performance problems in the allocation structure
128293Collective note: IS-U & IS-T performance problems
107100Sets: performance problems as of Release 4.0
105772CO05: Performance of order selection
95999Additional Info: Upgrading to 4.0B ORACLE
93292Additional Info: Upgrading to 4.0A ORACLE