db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nirmal Fernando <nirmal070...@gmail.com>
Subject What should the "Graphical Query Explainer" shows?
Date Fri, 28 May 2010 13:29:53 GMT
Hi All,

I like to get your ideas on what should the "Graphical Query Explainer"
convey to a viewer? Of course we can enhance as more information needed
But it's better to put up the most important information.

I've thought of including following after some thinking and also after
referring to PostgreSQL's graphical query explainer.

   - Statement executed
   - Type of scan performed (eg: TABLESCAN, INDEXSCAN, PROJECTION)
   - Estimated cost by the Optimizer
   - Estimated rows by the Optimizer
   - Sort/Scan type

Your comments/thoughts would be nice.


Best Regards,

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

View raw message