SAP Knowledge Base Article - Preview

2708709 - High estimate LIO numbers for "StoreIndex" and "Insert Worktable1".

Symptom

Showplan output of plan cost shows unexpectedly high estimate LIO numbers for "StoreIndex" and "Insert Worktable1"

Example: 

The Lava Operator Tree output below shows a cost of er:1.049e+06 although the base table has only 3072 rows

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


                                                Emit
                                                (VA = 7)
                                                r:1.049e+06 er:1.049e+06 
                                                cpu: 1500


                                     /
                                    Sequencer
                                    (VA = 6)
                                    r:1.049e+06 er:0

 

                         /                      \
                        StoreIndex              NestLoopJoin
                        (VA = 2)                Inner Join
                        r:1024 er:1025          (VA = 5)
                        l:612 el:308            r:1.049e+06 er:1.049e+06 
                        p:599 ep:606
                        cpu: 100 bufct: 26
             /                       /                      \
            Insert                  TableScan               IndexScan
            Worktable1              #src (a)                Worktable1
            (VA = 1)                (VA = 3)                (VA = 4)
            r:1024 er:1025          r:1024 er:1025          r:1.049e+06 er:1.049e+06 <<<<
            l:1285 el:1025          l:768 el:768            l:265065 el:262644
            p:0 ep:255              p:0 ep:768              p:0 ep:256
/
TableScan
#src (b)
(VA = 0)
r:1024 er:1025
l:768 el:768
p:0 ep:768

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

 


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 817100 , CR817100 , 817100, StoreIndex, Reformatting. , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.