Hi, 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? Amir
