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.
