Re: Error on using Ant to build Derby, Ant can not find compiler

On 2/4/07, Liese liu [EMAIL PROTECTED] wrote: Hej everybody, I am a newer of Derby. I download the db-derby-10.2.2.0-src.zip, when i use Ant 1.6.5 build it, it alwasy occures the same error, i.e. Compiler Adapter can't be found. My OS is Win XP, following is my ant.properties and the build

indexes

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

Re: indexes

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? Hi Amir, I don't know a way to get any suggestions about indexes which could have