SAP Note 135048 - Long runtimes statements w/ ROWNUM <= condition

Component : Backoffice Service Delivery - Oracle

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

Key words :
optimizer, performance, matchcode, search help, full table scan, CBO

Related Notes :

772497FAQ: Oracle Hints
766349FAQ: Oracle SQL optimization
618868FAQ: Oracle performance
385139Performance Select M_VMVAA
215917Easy change from Rule to Cost-Based Optimizer
191565F4 help slow during street call
176754Problems with CBO and RBO
170282use_hints profile parameter under NT
164238Performance matchcode search ac.to p. order number
127715CBO: Optimum parameters for performance