Are there routines to sweep SharedMedia and other thumbnail folders to verify existence and/or erase obsolete files? I automatically curate the Resources folders from Windows.

Rebuild word lookup tables? When I used query to change special song title identifier from (*) to (GRBC) I still had to click on each song title to enter rename mode and click next song to leave rename mode (didn't change title) before contains selector worked in collection rule.

Verify other table relationships (orphan rows) are valid?

Verify values in fields (font size, margins, etc.) are valid?

This maintenance routine would be thorough and rarely used but would ensure database integrity.