Aw: bad performance of LIMIT/OFFSET

17 Oct 2014


      Forgot to append the EXPLAIN output:

EXPLAIN
SELECT
	vkont
FROM
	sapsr3.dfkkop
WHERE
	vkont = '000802037649'
;


mal                                                                                                                                     
--------------------------------------------------------------------------------------------------------------------------------------  
function user.s9_3{autoCommit=true}(A0:str):void;                                                                                       
X_3 := sql.mvc();                                                                                                                       
X_7 := sql.bind(X_3,"sapsr3","dfkkop","vkont",0);                                                                                       
X_4:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop");                                                                                  
X_39 := algebra.subselect(X_7,X_4,A0,A0,true,true,false);                                                                               
(X_10,r1_10) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2);                                                                              
X_40 := algebra.subselect(r1_10,A0,A0,true,true,false);                                                                                 
X_13 := sql.bind(X_3,"sapsr3","dfkkop","vkont",1);                                                                                      
X_41 := algebra.subselect(X_13,X_4,A0,A0,true,true,false);                                                                              
X_15 := sql.subdelta(X_39,X_4,X_10,X_40,X_41);                                                                                          
X_17 := sql.projectdelta(X_15,X_7,X_10,r1_10,X_13);                                                                                     
X_18 := sql.resultSet(1,1,X_17);                                                                                                        
sql.rsColumn(X_18,"sapsr3.dfkkop","vkont","varchar",12,0,X_17);                                                                         
X_23 := io.stdout();                                                                                                                    
sql.exportResult(X_23,X_18);                                                                                                            
end s9_3;                                                                                                                               
# querylog.define("explain\nselect\n\tvkont\nfrom\n\tsapsr3.dfkkop\nwhere\n\t--1=1 and\n\tvkont = \\'000802037649\\';","default_pipe")  
# optimizer.mitosis()                                                                                                                   
# optimizer.dataflow()                                                                                                                  


EXPLAIN
SELECT
	vkont
FROM
	sapsr3.dfkkop
WHERE
	vkont = '000802037649'
LIMIT 1 OFFSET 0
;


mal                                                                                                                                                       
--------------------------------------------------------------------------------------------------------------------------------------------------------  
function user.s10_3{autoCommit=true}(A0:str):void;                                                                                                        
barrier X_696 := language.dataflow();                                                                                                                     
X_3 := sql.mvc();                                                                                                                                         
X_88:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,0,24);                                                                                   
X_39:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",0,24);                                                                                              
X_259 := algebra.subselect(X_88,X_39,A0,A0,true,true,false);                                                                                              
(X_138:bat[:oid,:oid] ,X_139:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,0,24);                                                          
X_307 := algebra.subselect(X_139,A0,A0,true,true,false);                                                                                                  
X_355 := sql.subdelta(X_259,X_39,X_138,X_307);                                                                                                            
X_403 := sql.projectdelta(X_355,X_88,X_138,X_139);                                                                                                        
X_452 := algebra.subslice(X_403,0:wrd,0:wrd);                                                                                                             
X_90:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,1,24);                                                                                   
X_41:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",1,24);                                                                                              
X_261 := algebra.subselect(X_90,X_41,A0,A0,true,true,false);                                                                                              
(X_141:bat[:oid,:oid] ,X_142:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,1,24);                                                          
X_309 := algebra.subselect(X_142,A0,A0,true,true,false);                                                                                                  
X_357 := sql.subdelta(X_261,X_41,X_141,X_309);                                                                                                            
X_405 := sql.projectdelta(X_357,X_90,X_141,X_142);                                                                                                        
X_453 := algebra.subslice(X_405,0:wrd,0:wrd);                                                                                                             
X_92:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,2,24);                                                                                   
X_43:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",2,24);                                                                                              
X_263 := algebra.subselect(X_92,X_43,A0,A0,true,true,false);                                                                                              
(X_144:bat[:oid,:oid] ,X_145:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,2,24);                                                          
X_311 := algebra.subselect(X_145,A0,A0,true,true,false);                                                                                                  
X_359 := sql.subdelta(X_263,X_43,X_144,X_311);                                                                                                            
X_407 := sql.projectdelta(X_359,X_92,X_144,X_145);                                                                                                        
X_454 := algebra.subslice(X_407,0:wrd,0:wrd);                                                                                                             
X_94:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,3,24);                                                                                   
X_45:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",3,24);                                                                                              
X_265 := algebra.subselect(X_94,X_45,A0,A0,true,true,false);                                                                                              
(X_147:bat[:oid,:oid] ,X_148:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,3,24);                                                          
X_313 := algebra.subselect(X_148,A0,A0,true,true,false);                                                                                                  
X_361 := sql.subdelta(X_265,X_45,X_147,X_313);                                                                                                            
X_409 := sql.projectdelta(X_361,X_94,X_147,X_148);                                                                                                        
X_455 := algebra.subslice(X_409,0:wrd,0:wrd);                                                                                                             
X_96:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,4,24);                                                                                   
X_47:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",4,24);                                                                                              
X_267 := algebra.subselect(X_96,X_47,A0,A0,true,true,false);                                                                                              
(X_150:bat[:oid,:oid] ,X_151:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,4,24);                                                          
X_315 := algebra.subselect(X_151,A0,A0,true,true,false);                                                                                                  
X_363 := sql.subdelta(X_267,X_47,X_150,X_315);                                                                                                            
X_411 := sql.projectdelta(X_363,X_96,X_150,X_151);                                                                                                        
X_456 := algebra.subslice(X_411,0:wrd,0:wrd);                                                                                                             
X_98:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,5,24);                                                                                   
X_49:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",5,24);                                                                                              
X_269 := algebra.subselect(X_98,X_49,A0,A0,true,true,false);                                                                                              
(X_153:bat[:oid,:oid] ,X_154:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,5,24);                                                          
X_317 := algebra.subselect(X_154,A0,A0,true,true,false);                                                                                                  
X_365 := sql.subdelta(X_269,X_49,X_153,X_317);                                                                                                            
X_413 := sql.projectdelta(X_365,X_98,X_153,X_154);                                                                                                        
X_457 := algebra.subslice(X_413,0:wrd,0:wrd);                                                                                                             
X_100:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,6,24);                                                                                  
X_51:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",6,24);                                                                                              
X_271 := algebra.subselect(X_100,X_51,A0,A0,true,true,false);                                                                                             
(X_156:bat[:oid,:oid] ,X_157:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,6,24);                                                          
X_319 := algebra.subselect(X_157,A0,A0,true,true,false);                                                                                                  
X_367 := sql.subdelta(X_271,X_51,X_156,X_319);                                                                                                            
X_415 := sql.projectdelta(X_367,X_100,X_156,X_157);                                                                                                       
X_458 := algebra.subslice(X_415,0:wrd,0:wrd);                                                                                                             
X_102:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,7,24);                                                                                  
X_53:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",7,24);                                                                                              
X_273 := algebra.subselect(X_102,X_53,A0,A0,true,true,false);                                                                                             
(X_159:bat[:oid,:oid] ,X_160:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,7,24);                                                          
X_321 := algebra.subselect(X_160,A0,A0,true,true,false);                                                                                                  
X_369 := sql.subdelta(X_273,X_53,X_159,X_321);                                                                                                            
X_417 := sql.projectdelta(X_369,X_102,X_159,X_160);                                                                                                       
X_459 := algebra.subslice(X_417,0:wrd,0:wrd);                                                                                                             
X_105:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,8,24);                                                                                  
X_55:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",8,24);                                                                                              
X_275 := algebra.subselect(X_105,X_55,A0,A0,true,true,false);                                                                                             
(X_162:bat[:oid,:oid] ,X_163:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,8,24);                                                          
X_323 := algebra.subselect(X_163,A0,A0,true,true,false);                                                                                                  
X_371 := sql.subdelta(X_275,X_55,X_162,X_323);                                                                                                            
X_419 := sql.projectdelta(X_371,X_105,X_162,X_163);                                                                                                       
X_460 := algebra.subslice(X_419,0:wrd,0:wrd);                                                                                                             
X_107:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,9,24);                                                                                  
X_57:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",9,24);                                                                                              
X_277 := algebra.subselect(X_107,X_57,A0,A0,true,true,false);                                                                                             
(X_165:bat[:oid,:oid] ,X_166:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,9,24);                                                          
X_325 := algebra.subselect(X_166,A0,A0,true,true,false);                                                                                                  
X_373 := sql.subdelta(X_277,X_57,X_165,X_325);                                                                                                            
X_421 := sql.projectdelta(X_373,X_107,X_165,X_166);                                                                                                       
X_461 := algebra.subslice(X_421,0:wrd,0:wrd);                                                                                                             
X_109:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,10,24);                                                                                 
X_59:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",10,24);                                                                                             
X_279 := algebra.subselect(X_109,X_59,A0,A0,true,true,false);                                                                                             
(X_168:bat[:oid,:oid] ,X_169:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,10,24);                                                         
X_327 := algebra.subselect(X_169,A0,A0,true,true,false);                                                                                                  
X_375 := sql.subdelta(X_279,X_59,X_168,X_327);                                                                                                            
X_423 := sql.projectdelta(X_375,X_109,X_168,X_169);                                                                                                       
X_462 := algebra.subslice(X_423,0:wrd,0:wrd);                                                                                                             
X_111:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,11,24);                                                                                 
X_61:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",11,24);                                                                                             
X_281 := algebra.subselect(X_111,X_61,A0,A0,true,true,false);                                                                                             
(X_172:bat[:oid,:oid] ,X_173:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,11,24);                                                         
X_329 := algebra.subselect(X_173,A0,A0,true,true,false);                                                                                                  
X_377 := sql.subdelta(X_281,X_61,X_172,X_329);                                                                                                            
X_425 := sql.projectdelta(X_377,X_111,X_172,X_173);                                                                                                       
X_463 := algebra.subslice(X_425,0:wrd,0:wrd);                                                                                                             
X_113:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,12,24);                                                                                 
X_63:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",12,24);                                                                                             
X_283 := algebra.subselect(X_113,X_63,A0,A0,true,true,false);                                                                                             
(X_175:bat[:oid,:oid] ,X_176:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,12,24);                                                         
X_331 := algebra.subselect(X_176,A0,A0,true,true,false);                                                                                                  
X_379 := sql.subdelta(X_283,X_63,X_175,X_331);                                                                                                            
X_427 := sql.projectdelta(X_379,X_113,X_175,X_176);                                                                                                       
X_464 := algebra.subslice(X_427,0:wrd,0:wrd);                                                                                                             
X_115:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,13,24);                                                                                 
X_65:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",13,24);                                                                                             
X_285 := algebra.subselect(X_115,X_65,A0,A0,true,true,false);                                                                                             
(X_178:bat[:oid,:oid] ,X_179:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,13,24);                                                         
X_333 := algebra.subselect(X_179,A0,A0,true,true,false);                                                                                                  
X_381 := sql.subdelta(X_285,X_65,X_178,X_333);                                                                                                            
X_429 := sql.projectdelta(X_381,X_115,X_178,X_179);                                                                                                       
X_465 := algebra.subslice(X_429,0:wrd,0:wrd);                                                                                                             
X_117:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,14,24);                                                                                 
X_67:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",14,24);                                                                                             
X_287 := algebra.subselect(X_117,X_67,A0,A0,true,true,false);                                                                                             
(X_181:bat[:oid,:oid] ,X_182:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,14,24);                                                         
X_335 := algebra.subselect(X_182,A0,A0,true,true,false);                                                                                                  
X_383 := sql.subdelta(X_287,X_67,X_181,X_335);                                                                                                            
X_431 := sql.projectdelta(X_383,X_117,X_181,X_182);                                                                                                       
X_466 := algebra.subslice(X_431,0:wrd,0:wrd);                                                                                                             
X_119:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,15,24);                                                                                 
X_69:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",15,24);                                                                                             
X_289 := algebra.subselect(X_119,X_69,A0,A0,true,true,false);                                                                                             
(X_184:bat[:oid,:oid] ,X_185:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,15,24);                                                         
X_337 := algebra.subselect(X_185,A0,A0,true,true,false);                                                                                                  
X_385 := sql.subdelta(X_289,X_69,X_184,X_337);                                                                                                            
X_433 := sql.projectdelta(X_385,X_119,X_184,X_185);                                                                                                       
X_467 := algebra.subslice(X_433,0:wrd,0:wrd);                                                                                                             
X_121:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,16,24);                                                                                 
X_72:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",16,24);                                                                                             
X_291 := algebra.subselect(X_121,X_72,A0,A0,true,true,false);                                                                                             
(X_187:bat[:oid,:oid] ,X_188:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,16,24);                                                         
X_339 := algebra.subselect(X_188,A0,A0,true,true,false);                                                                                                  
X_387 := sql.subdelta(X_291,X_72,X_187,X_339);                                                                                                            
X_435 := sql.projectdelta(X_387,X_121,X_187,X_188);                                                                                                       
X_468 := algebra.subslice(X_435,0:wrd,0:wrd);                                                                                                             
X_123:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,17,24);                                                                                 
X_74:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",17,24);                                                                                             
X_293 := algebra.subselect(X_123,X_74,A0,A0,true,true,false);                                                                                             
(X_190:bat[:oid,:oid] ,X_191:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,17,24);                                                         
X_341 := algebra.subselect(X_191,A0,A0,true,true,false);                                                                                                  
X_389 := sql.subdelta(X_293,X_74,X_190,X_341);                                                                                                            
X_437 := sql.projectdelta(X_389,X_123,X_190,X_191);                                                                                                       
X_469 := algebra.subslice(X_437,0:wrd,0:wrd);                                                                                                             
X_125:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,18,24);                                                                                 
X_76:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",18,24);                                                                                             
X_295 := algebra.subselect(X_125,X_76,A0,A0,true,true,false);                                                                                             
(X_193:bat[:oid,:oid] ,X_194:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,18,24);                                                         
X_343 := algebra.subselect(X_194,A0,A0,true,true,false);                                                                                                  
X_391 := sql.subdelta(X_295,X_76,X_193,X_343);                                                                                                            
X_439 := sql.projectdelta(X_391,X_125,X_193,X_194);                                                                                                       
X_470 := algebra.subslice(X_439,0:wrd,0:wrd);                                                                                                             
X_127:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,19,24);                                                                                 
X_78:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",19,24);                                                                                             
X_297 := algebra.subselect(X_127,X_78,A0,A0,true,true,false);                                                                                             
(X_196:bat[:oid,:oid] ,X_197:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,19,24);                                                         
X_345 := algebra.subselect(X_197,A0,A0,true,true,false);                                                                                                  
X_393 := sql.subdelta(X_297,X_78,X_196,X_345);                                                                                                            
X_441 := sql.projectdelta(X_393,X_127,X_196,X_197);                                                                                                       
X_471 := algebra.subslice(X_441,0:wrd,0:wrd);                                                                                                             
X_129:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,20,24);                                                                                 
X_80:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",20,24);                                                                                             
X_299 := algebra.subselect(X_129,X_80,A0,A0,true,true,false);                                                                                             
(X_199:bat[:oid,:oid] ,X_200:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,20,24);                                                         
X_347 := algebra.subselect(X_200,A0,A0,true,true,false);                                                                                                  
X_395 := sql.subdelta(X_299,X_80,X_199,X_347);                                                                                                            
X_443 := sql.projectdelta(X_395,X_129,X_199,X_200);                                                                                                       
X_472 := algebra.subslice(X_443,0:wrd,0:wrd);                                                                                                             
X_131:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,21,24);                                                                                 
X_82:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",21,24);                                                                                             
X_301 := algebra.subselect(X_131,X_82,A0,A0,true,true,false);                                                                                             
(X_202:bat[:oid,:oid] ,X_203:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,21,24);                                                         
X_349 := algebra.subselect(X_203,A0,A0,true,true,false);                                                                                                  
X_397 := sql.subdelta(X_301,X_82,X_202,X_349);                                                                                                            
X_445 := sql.projectdelta(X_397,X_131,X_202,X_203);                                                                                                       
X_473 := algebra.subslice(X_445,0:wrd,0:wrd);                                                                                                             
X_133:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,22,24);                                                                                 
X_84:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",22,24);                                                                                             
X_303 := algebra.subselect(X_133,X_84,A0,A0,true,true,false);                                                                                             
(X_206:bat[:oid,:oid] ,X_207:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,22,24);                                                         
X_351 := algebra.subselect(X_207,A0,A0,true,true,false);                                                                                                  
X_399 := sql.subdelta(X_303,X_84,X_206,X_351);                                                                                                            
X_447 := sql.projectdelta(X_399,X_133,X_206,X_207);                                                                                                       
X_474 := algebra.subslice(X_447,0:wrd,0:wrd);                                                                                                             
X_135:bat[:oid,:str]  := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,23,24);                                                                                 
X_86:bat[:oid,:oid]  := sql.tid(X_3,"sapsr3","dfkkop",23,24);                                                                                             
X_305 := algebra.subselect(X_135,X_86,A0,A0,true,true,false);                                                                                             
(X_209:bat[:oid,:oid] ,X_210:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,23,24);                                                         
X_353 := algebra.subselect(X_210,A0,A0,true,true,false);                                                                                                  
X_9 := sql.bind(X_3,"sapsr3","dfkkop","vkont",1);                                                                                                         
X_36 := algebra.subselect(X_9,X_86,A0,A0,true,true,false);                                                                                                
X_401 := sql.subdelta(X_305,X_86,X_209,X_353,X_36);                                                                                                       
X_449 := sql.projectdelta(X_401,X_135,X_209,X_210,X_9);                                                                                                   
X_475 := algebra.subslice(X_449,0:wrd,0:wrd);                                                                                                             
X_502 := mat.packIncrement(X_452,24);                                                                                                                     
X_504 := mat.packIncrement(X_502,X_453);                                                                                                                  
X_505 := mat.packIncrement(X_504,X_454);                                                                                                                  
X_506 := mat.packIncrement(X_505,X_455);                                                                                                                  
X_507 := mat.packIncrement(X_506,X_456);                                                                                                                  
X_508 := mat.packIncrement(X_507,X_457);                                                                                                                  
X_509 := mat.packIncrement(X_508,X_458);                                                                                                                  
X_510 := mat.packIncrement(X_509,X_459);                                                                                                                  
X_511 := mat.packIncrement(X_510,X_460);                                                                                                                  
X_512 := mat.packIncrement(X_511,X_461);                                                                                                                  
X_513 := mat.packIncrement(X_512,X_462);                                                                                                                  
X_514 := mat.packIncrement(X_513,X_463);                                                                                                                  
X_515 := mat.packIncrement(X_514,X_464);                                                                                                                  
X_516 := mat.packIncrement(X_515,X_465);                                                                                                                  
X_517 := mat.packIncrement(X_516,X_466);                                                                                                                  
X_518 := mat.packIncrement(X_517,X_467);                                                                                                                  
X_519 := mat.packIncrement(X_518,X_468);                                                                                                                  
X_520 := mat.packIncrement(X_519,X_469);                                                                                                                  
X_521 := mat.packIncrement(X_520,X_470);                                                                                                                  
X_522 := mat.packIncrement(X_521,X_471);                                                                                                                  
X_523 := mat.packIncrement(X_522,X_472);                                                                                                                  
X_524 := mat.packIncrement(X_523,X_473);                                                                                                                  
X_525 := mat.packIncrement(X_524,X_474);                                                                                                                  
X_476 := mat.packIncrement(X_525,X_475);                                                                                                                  
X_13 := algebra.subslice(X_476,0:wrd,0:wrd);                                                                                                              
X_478 := algebra.leftfetchjoin(X_452,X_403);                                                                                                              
X_479 := algebra.leftfetchjoin(X_453,X_405);                                                                                                              
X_480 := algebra.leftfetchjoin(X_454,X_407);                                                                                                              
X_481 := algebra.leftfetchjoin(X_455,X_409);                                                                                                              
X_482 := algebra.leftfetchjoin(X_456,X_411);                                                                                                              
X_483 := algebra.leftfetchjoin(X_457,X_413);                                                                                                              
X_484 := algebra.leftfetchjoin(X_458,X_415);                                                                                                              
X_485 := algebra.leftfetchjoin(X_459,X_417);                                                                                                              
X_486 := algebra.leftfetchjoin(X_460,X_419);                                                                                                              
X_487 := algebra.leftfetchjoin(X_461,X_421);                                                                                                              
X_488 := algebra.leftfetchjoin(X_462,X_423);                                                                                                              
X_489 := algebra.leftfetchjoin(X_463,X_425);                                                                                                              
X_490 := algebra.leftfetchjoin(X_464,X_427);                                                                                                              
X_491 := algebra.leftfetchjoin(X_465,X_429);                                                                                                              
X_492 := algebra.leftfetchjoin(X_466,X_431);                                                                                                              
X_493 := algebra.leftfetchjoin(X_467,X_433);                                                                                                              
X_494 := algebra.leftfetchjoin(X_468,X_435);                                                                                                              
X_495 := algebra.leftfetchjoin(X_469,X_437);                                                                                                              
X_496 := algebra.leftfetchjoin(X_470,X_439);                                                                                                              
X_497 := algebra.leftfetchjoin(X_471,X_441);                                                                                                              
X_498 := algebra.leftfetchjoin(X_472,X_443);                                                                                                              
X_499 := algebra.leftfetchjoin(X_473,X_445);                                                                                                              
X_500 := algebra.leftfetchjoin(X_474,X_447);                                                                                                              
X_501 := algebra.leftfetchjoin(X_475,X_449);                                                                                                              
X_527 := mat.packIncrement(X_478,24);                                                                                                                     
X_528 := mat.packIncrement(X_527,X_479);                                                                                                                  
X_529 := mat.packIncrement(X_528,X_480);                                                                                                                  
X_530 := mat.packIncrement(X_529,X_481);                                                                                                                  
X_531 := mat.packIncrement(X_530,X_482);                                                                                                                  
X_532 := mat.packIncrement(X_531,X_483);                                                                                                                  
X_533 := mat.packIncrement(X_532,X_484);                                                                                                                  
X_534 := mat.packIncrement(X_533,X_485);                                                                                                                  
X_535 := mat.packIncrement(X_534,X_486);                                                                                                                  
X_536 := mat.packIncrement(X_535,X_487);                                                                                                                  
X_537 := mat.packIncrement(X_536,X_488);                                                                                                                  
X_538 := mat.packIncrement(X_537,X_489);                                                                                                                  
X_539 := mat.packIncrement(X_538,X_490);                                                                                                                  
X_540 := mat.packIncrement(X_539,X_491);                                                                                                                  
X_541 := mat.packIncrement(X_540,X_492);                                                                                                                  
X_542 := mat.packIncrement(X_541,X_493);                                                                                                                  
X_543 := mat.packIncrement(X_542,X_494);                                                                                                                  
X_544 := mat.packIncrement(X_543,X_495);                                                                                                                  
X_545 := mat.packIncrement(X_544,X_496);                                                                                                                  
X_546 := mat.packIncrement(X_545,X_497);                                                                                                                  
X_547 := mat.packIncrement(X_546,X_498);                                                                                                                  
X_548 := mat.packIncrement(X_547,X_499);                                                                                                                  
X_549 := mat.packIncrement(X_548,X_500);                                                                                                                  
X_477 := mat.packIncrement(X_549,X_501);                                                                                                                  
X_14 := algebra.leftfetchjoin(X_13,X_477);                                                                                                                
language.pass(X_39);                                                                                                                                      
language.pass(X_88);                                                                                                                                      
language.pass(X_138);                                                                                                                                     
language.pass(X_139);                                                                                                                                     
language.pass(X_41);                                                                                                                                      
language.pass(X_90);                                                                                                                                      
language.pass(X_141);                                                                                                                                     
language.pass(X_142);                                                                                                                                     
language.pass(X_43);                                                                                                                                      
language.pass(X_92);                                                                                                                                      
language.pass(X_144);                                                                                                                                     
language.pass(X_145);                                                                                                                                     
language.pass(X_45);                                                                                                                                      
language.pass(X_94);                                                                                                                                      
language.pass(X_147);                                                                                                                                     
language.pass(X_148);                                                                                                                                     
language.pass(X_47);                                                                                                                                      
language.pass(X_96);                                                                                                                                      
language.pass(X_150);                                                                                                                                     
language.pass(X_151);                                                                                                                                     
language.pass(X_49);                                                                                                                                      
language.pass(X_98);                                                                                                                                      
language.pass(X_153);                                                                                                                                     
language.pass(X_154);                                                                                                                                     
language.pass(X_51);                                                                                                                                      
language.pass(X_100);                                                                                                                                     
language.pass(X_156);                                                                                                                                     
language.pass(X_157);                                                                                                                                     
language.pass(X_53);                                                                                                                                      
language.pass(X_102);                                                                                                                                     
language.pass(X_159);                                                                                                                                     
language.pass(X_160);                                                                                                                                     
language.pass(X_55);                                                                                                                                      
language.pass(X_105);                                                                                                                                     
language.pass(X_162);                                                                                                                                     
language.pass(X_163);                                                                                                                                     
language.pass(X_57);                                                                                                                                      
language.pass(X_107);                                                                                                                                     
language.pass(X_165);                                                                                                                                     
language.pass(X_166);                                                                                                                                     
language.pass(X_59);                                                                                                                                      
language.pass(X_109);                                                                                                                                     
language.pass(X_168);                                                                                                                                     
language.pass(X_169);                                                                                                                                     
language.pass(X_61);                                                                                                                                      
language.pass(X_111);                                                                                                                                     
language.pass(X_172);                                                                                                                                     
language.pass(X_173);                                                                                                                                     
language.pass(X_63);                                                                                                                                      
language.pass(X_113);                                                                                                                                     
language.pass(X_175);                                                                                                                                     
language.pass(X_176);                                                                                                                                     
language.pass(X_65);                                                                                                                                      
language.pass(X_115);                                                                                                                                     
language.pass(X_178);                                                                                                                                     
language.pass(X_179);                                                                                                                                     
language.pass(X_67);                                                                                                                                      
language.pass(X_117);                                                                                                                                     
language.pass(X_181);                                                                                                                                     
language.pass(X_182);                                                                                                                                     
language.pass(X_69);                                                                                                                                      
language.pass(X_119);                                                                                                                                     
language.pass(X_184);                                                                                                                                     
language.pass(X_185);                                                                                                                                     
language.pass(X_72);                                                                                                                                      
language.pass(X_121);                                                                                                                                     
language.pass(X_187);                                                                                                                                     
language.pass(X_188);                                                                                                                                     
language.pass(X_74);                                                                                                                                      
language.pass(X_123);                                                                                                                                     
language.pass(X_190);                                                                                                                                     
language.pass(X_191);                                                                                                                                     
language.pass(X_76);                                                                                                                                      
language.pass(X_125);                                                                                                                                     
language.pass(X_193);                                                                                                                                     
language.pass(X_194);                                                                                                                                     
language.pass(X_78);                                                                                                                                      
language.pass(X_127);                                                                                                                                     
language.pass(X_196);                                                                                                                                     
language.pass(X_197);                                                                                                                                     
language.pass(X_80);                                                                                                                                      
language.pass(X_129);                                                                                                                                     
language.pass(X_199);                                                                                                                                     
language.pass(X_200);                                                                                                                                     
language.pass(X_82);                                                                                                                                      
language.pass(X_131);                                                                                                                                     
language.pass(X_202);                                                                                                                                     
language.pass(X_203);                                                                                                                                     
language.pass(X_84);                                                                                                                                      
language.pass(X_133);                                                                                                                                     
language.pass(X_206);                                                                                                                                     
language.pass(X_207);                                                                                                                                     
language.pass(X_86);                                                                                                                                      
language.pass(X_135);                                                                                                                                     
language.pass(X_209);                                                                                                                                     
language.pass(X_210);                                                                                                                                     
language.pass(X_9);                                                                                                                                       
language.pass(X_452);                                                                                                                                     
language.pass(X_403);                                                                                                                                     
language.pass(X_453);                                                                                                                                     
language.pass(X_405);                                                                                                                                     
language.pass(X_454);                                                                                                                                     
language.pass(X_407);                                                                                                                                     
language.pass(X_455);                                                                                                                                     
language.pass(X_409);                                                                                                                                     
language.pass(X_456);                                                                                                                                     
language.pass(X_411);                                                                                                                                     
language.pass(X_457);                                                                                                                                     
language.pass(X_413);                                                                                                                                     
language.pass(X_458);                                                                                                                                     
language.pass(X_415);                                                                                                                                     
language.pass(X_459);                                                                                                                                     
language.pass(X_417);                                                                                                                                     
language.pass(X_460);                                                                                                                                     
language.pass(X_419);                                                                                                                                     
language.pass(X_461);                                                                                                                                     
language.pass(X_421);                                                                                                                                     
language.pass(X_462);                                                                                                                                     
language.pass(X_423);                                                                                                                                     
language.pass(X_463);                                                                                                                                     
language.pass(X_425);                                                                                                                                     
language.pass(X_464);                                                                                                                                     
language.pass(X_427);                                                                                                                                     
language.pass(X_465);                                                                                                                                     
language.pass(X_429);                                                                                                                                     
language.pass(X_466);                                                                                                                                     
language.pass(X_431);                                                                                                                                     
language.pass(X_467);                                                                                                                                     
language.pass(X_433);                                                                                                                                     
language.pass(X_468);                                                                                                                                     
language.pass(X_435);                                                                                                                                     
language.pass(X_469);                                                                                                                                     
language.pass(X_437);                                                                                                                                     
language.pass(X_470);                                                                                                                                     
language.pass(X_439);                                                                                                                                     
language.pass(X_471);                                                                                                                                     
language.pass(X_441);                                                                                                                                     
language.pass(X_472);                                                                                                                                     
language.pass(X_443);                                                                                                                                     
language.pass(X_473);                                                                                                                                     
language.pass(X_445);                                                                                                                                     
language.pass(X_474);                                                                                                                                     
language.pass(X_447);                                                                                                                                     
language.pass(X_475);                                                                                                                                     
language.pass(X_449);                                                                                                                                     
exit X_696;                                                                                                                                               
X_15 := sql.resultSet(1,1,X_14);                                                                                                                          
sql.rsColumn(X_15,"sapsr3.dfkkop","vkont","varchar",12,0,X_14);                                                                                           
X_20 := io.stdout();                                                                                                                                      
sql.exportResult(X_20,X_15);                                                                                                                              
end s10_3;                                                                                                                                                
# querylog.define("explain\nselect\n\tvkont\nfrom\n\tsapsr3.dfkkop\nwhere\n\t--1=1 and\n\tvkont = \\'000802037649\\'\nlimit 1 offset 0;","default_pipe")

Aw: bad performance of LIMIT/OFFSET

gms_xy＠gmx.de