does anyone have any documentation on how to interpret the result of an explain ? I’m trying to improve some quite sophisticated xqueries so as to add any necessary index, but there is so many information in the result of the explain, it’s possible I miss some points in it.

Thanks !

Hi,

Recently I was also wondering how to understand ino:explain output of xquery. I didn’t find any documentation. There isn’t any documentation I guess. Where as, x-query ‘explain’ is documented (http://techcommunity.softwareag.com/ecosystem/documentation/crossvision/ins441/xqlref/explain.htm#explain).

What all I found about xquery-explain is that XQuery tool that comes with tamino (can be accessed standalone or via Tamino X-plorer), applies a styelsheet to the raw xml output and presents the result in readable format. It was enough for my purpose, because I just wanted to know whether my query was using index or not. Simple. I don’t know if any deeper information than that could be obtained from the xquery-explain output (even if it was documented).

So… if you happen to find out more about this, please post back the information. I am interested too.

Cheers,
Gopal

I had a few information from SAG. No documentation is available except for the basics (see http://techcommunity.softwareag.com/ecosystem/documentation/Crossvision/ins441/xqueryref/ref-TaminoQPIExplain.htm), it seems that SAG considers a deep analysis of an explain as a task for their own R&D.

However the referred page delivers 2 ou 3 useful things.