title: LINQ - Speeding up query that has a join to a huge table
body: <p>I have these two tables</p>
  
  <pre><code>ExpiredAccount                    Account
  --------------                    ---------------
  ExpiredAccountID                  AccountID
  AccountID (fk)                    AccountName
  ...                               ...
  </code></pre>
  
  <p>Basically, I want to return a list of ExpiredAccounts displaying the AccountName in the result.</p>
  
  <p>I currently do this using</p>
  
  <pre><code>var expiredAccounts = (from x in ExpiredAccount
                         join m in Account on x.AccountID equals m.AccountID
                         select m.AccountName).ToList()
  </code></pre>
  
  <p>This works fine. However, this takes too long.
  There's not a lot of records in expiredAccounts (&lt;200).
  The Account table on the otherhand has over 300,000 records.</p>
  
  <p>Is there anyway I could speed up my query, or alternatively, another way to do this more efficiently with or without using LINQ?</p>