Well... it doesn't give you the details you are asking, but please
take a look at my SQLiteManager, I think it could be useful to you:
http://www.sqlabs.net/sqlitemanager.php
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
On May 27, 2006, at 6:56 PM, Jay Sprenkle wrote:
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
