Symptom
- A select query with MAX() aggregate function on an allpages locked table may be slow when a lot of pages are read from disk on AIX platforms.
- The following information can be seen in the showplan messages.
|SCALAR AGGREGATE Operator (VA = 1)
| Evaluate Ungrouped MAXIMUM AGGREGATE.
| Scanning only up to the first qualifying row.
|
| |SCAN Operator (VA = 0)
| | FROM TABLE
| | <table name>
| | Using Clustered Index.
| | Index : <index name>
| | Backward scan.
| | Positioning at end of table.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
CR#826213 , CR826213 , #826213, descending , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.