Fast way to find unused table through system table info?

Question

In apache derby, I have to find the unused tables from the log or the system table provided by derby itself. Is there any reference?

I heard that oracle provides the function or the dictionary view for distinguishing unused table or unused index. So does SQL Server.

Answer 1

One way to approach this is as follows:

1. Run your application, with derby.language.logStatementText=true: http://db.apache.org/derby/docs/10.11/ref/rrefproper43517.html
2. Review your derby.log file, and see which tables are being referenced
3. Compare that list of tables to the total list of tables in your database.