title: An Alternative to Views?
body: <p>I am just reading <a href="http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx" rel="nofollow noreferrer"><strong>this</strong></a> article and I came across this:</p>
  
  <blockquote>
    <p>Filter: Remove any functions in the
    WHERE clause, don't include <strong>views</strong> in
    your Transact-SQL code, may need
    additional indexes.</p>
  </blockquote>
  
  <p>If I do not use views, what are the alternatives? I mean, in my situation, I want to select some data from a table and then use a few other select queries to work on the subset of data from the first select query?</p>
  
  <p>How can I do this efficiently?</p>
  
  <p>Thanks all</p>