Although I don't think it matters the type of database whose table you are adding an index to, do you think I would have to update the index when I am adding records into the table? I plan on adding an index to the ID column of a table, and do not know if I would have to programmatically update this index when I add a new record to the table.
Indexes are automatically recalculated when an insert happens, Derby is no exception in that case.