db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nirmal Fernando <nirmal070...@gmail.com>
Subject Re: What should the "Graphical Query Explainer" shows?
Date Sat, 29 May 2010 05:27:06 GMT
Hi Again,

> Where can I get the values for the "node type" and "pages visited",
> are they in the SYSXPLAIN tables (I didn't notice these there)?
>

Pages visited is there in the SYSXPLAIN_SCAN_PROPS system table as
NO_VISITED_PAGES, sorry about that.

But what you meant by "node type" is not clear to me (Is it STMT_TYPE?) .

Thanks.

-- 
Best Regards,
Nirmal

C.S.Nirmal J. Fernando
Department of Computer Science & Engineering,
Faculty of Engineering,
University of Moratuwa,
Sri Lanka.

Mime
View raw message