Can I get the query to use an Index Seek instead of Clustered Index Scan
SQL seems to be doing an INDEX SCAN on all the SUB Tables that are part of the INNER JOINS. How do I change the query to get an INDEX SEEK
This looks like a pretty reasonable execution plan to me. The only table that has more than a few thousand rows is BankTransactions and that is the one using an index seek already. Scans are not always a bad thing.