Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DBA Cockpit - Explain - intrepeting results

Hello,

I've been using DBA Cockpit to look at how queries are being planned - the database being queried is Sybase ASE.

I did some test queries on LIPS and VBAP e.g.

SELECT lips~vbeln lips~posnr
 
FROM lips
  INNER
JOIN vbap
   
ON lips~vgbel = vbap~vbeln AND lips~vgpos = vbap~posnr
 
INTO TABLE gt_vbeln
 
WHERE vbap~vbeln = p_sa_doc.

Which I could see was using a index LIPS~Z01 we have set up on fields VGBEL, VGPOS. The above query did IndexScans and then did a MergeJoin.

I then tried a similar query, but which didn't fully use the index:

SELECT lips~vbeln lips~posnr
 
FROM lips
  INNER
JOIN vbap
   
ON lips~vgbel = vbap~vbeln 
 
INTO TABLE gt_vbeln
 
WHERE vbap~vbeln = p_sa_doc.

This resulted in a StoreIndex on VBAP and a NestLoopJoin.

Does anyone know some good resources for learning about the different operations that appear in the flow diagrams in DBA Cockpit e.g. 'StoreIndex', 'NestLoopJoin'.

Is there any documentation or any books you could recommend? Thank you, Chris

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question