SAP Knowledge Base Article - Preview

2726078 - Partial run of a query shows inaccurate values for the "actual logical reads" - ASE

Symptom

  • Partial run of a query shows inaccurate values for the "actual logical reads" represented by "l" in the "Index Scan Worktable1", "Insert WorkTable1" and "Stored Index" nodes.
  • The "l" values for the three nodes are the same and different from the values for a full/complete run.
  • This behavior is misleading for troubleshooting queries. 
  • Below is just a small table with only 3072 rows; the larger the dataset the more inaccuracy of the values.

 

                        StoreIndex                  Insert                           IndexScan

                                                            Worktable1                Worktable1

Partial Run      l:2787                          l:2787                          l:2787

Full Run           l:14                              l:1031                          l:6165

 

Partial Run Output shows inaccurate values for "l"

==================== Lava Operator Tree ====================

                                                Emit

                                                (VA = 8)

                                                r:0 er:1.049e+06

                                                cpu: 0

                                        /

                                        Sequencer

                                        (VA = 7)

                                        r:356520 er:0

                         /                                                     \

                        StoreIndex                                  Insert

                        (VA = 2)                            #dst

                        r:1024 er:1025                           (VA = 6)

                        l:2787 el:6                                   r:356520 er:1.049e+06

                        p:5 ep:0                                       l:364914 el:258562

                        cpu: 100 bufct: 24                      p:0 ep:258562

             /                                     /

            Insert                              NestLoopJoin

            Worktable1                   Inner Join

            (VA = 1)                          (VA = 5)

            r:1024 er:1025              r:356521 er:1.049e+06

            l:2787 el:1025

            p:0 ep:2

 /                                    /                                     \

TableScan                     TableScan                     IndexScan

#src (b)                          #src (a)                          Worktable1

(VA = 0)                         (VA = 3)                         (VA = 4)

r:1024 er:1025             r:349 er:1025               r:356521 er:1.049e+06

l:768 el:768                  l:262 el:768                   l:2787 el:3597

p:0 ep:768                    p:423 ep:768                p:0 ep:4

============================================================


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR 817537 , CR817537 , 817537 ,  Partial run of a query , inaccurate values actual logical reads , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.