3055863 - Suboptimal query plan with n-ary nested loop join and table scan to access big table after data cache increased -- SAP ASE

• Optimizer picks up optimal query plan with n-ary nested loop join and index scan to access a big DOL table with default data cache size  < 30 Gbs.
• Optimizer picks up suboptimal query plan using n-ary nested loop join and table scan to access a big DOL table after default data cache size is increased to 40G.

SAP Adaptive Server Enterprise (ASE) 16.0 SP03

824726, CR 824726, table scan, suboptimal query plan, big data cache size, concurrency_opt_threshold , KBA , large default data cache , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed