Investigate performance of metadata queries
Investigate the performance of the following DB calls to see which indexes are being used, and whether adding new indexes would improve performance:
- Database#getGroupMetadata(T, GroupId)
- Database#getMessageMetadata(T, GroupId)
- Database#getMessageMetadata(T, GroupId, Metadata)
- Database#getMessageMetadata(T, MessageId)
- Database#getMessageMetadataForValidator(T, MessageId)
http://www.h2database.com/html/performance.html#explain_plan