There’s also notmuch with various frontends which will let you index and search colossal mail accounts

https://notmuchmail.org/frontends/