db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amir Michail" <amich...@gmail.com>
Subject indexes
Date Sun, 04 Feb 2007 20:09:52 GMT

Is there a way to get derby db to give a warning whenever it processes
a query that would benefit significantly from the creation of
additional index(es)?

Also, how do I find out all the (possibly compound field) indexes that
have been created for a table?

Finally, is there a way to dump the db to a file of SQL commands that
can be used to reconstruct the db?


View raw message