Accounts table for Solana

Instead of trying to use the costly "array_contains()" function to pull transactions involving an account, could we use an indexed many-to-many mapping table? 2 columns: account_key, tx_id And we could join that back to the transactions table to pull the txns we need.