On 5/27/06, Mikey C <[EMAIL PROTECTED]> wrote:
Hi, Does anyone know of a tool that can use the output of the explain statement to produce something akin to: http://www.nldelphi.com/artimages/sqls38.jpg Which is what MS SQL Server gives. When developing queries it would be good to see how different queries compare in terms of relative cost. eg. http://www.sql-server-performance.com/images/jc_sql_server_quantative_analysis2_image010.jpg Could such an output be derived from the explain in SQLite, but in a simple graphical output with relative (%) cost?
That would be a pretty useful optimization tool, sorry I don't know of one. -- SqliteImporter, SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite
