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
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.