title: How to create indeed.com like search?
body: <p>If you have used indeed.com before, you may know that for the keywords you look for, it returns a traditional search results as long as multiple search refinement options on the left side of screen.</p>
  
  <p>For example, searching for keyword "designer", the refinement options are:</p>
  
  <pre><code>Salary Estimate
      $40,000+ (45982)
      $60,000+ (29795)
      $80,000+ (15966)
      $100,000+ (6896)
      $120,000+ (2828)
  Title
      Floral Design Specialist (945)
      Hair Stylist (817)
      GRAPHIC DESIGNER (630)
      Hourly Associates/Co-managers (589)
      Web designer (584)
      more »
  Company
      Kelly Services (1862)
      Unlisted Company (1133)
      CyberCoders Engineering (1058)
      Michaels Arts &amp; Crafts (947)
      ULTA (818)
      Elance (767)
  Location
      New York, NY (2960)
      San Francisco, CA (1633)
      Chicago, IL (1184)
      Houston, TX (1057)
      Seattle, WA (1025)
      more »
  Job Type
      Full-time (45687)
      Part-time (2196)
      Contract (8204)
      Internship (720)
      Temporary (1093)
  </code></pre>
  
  <p>How does it gather statistics information so quickly (e.g. the number of job offers in each salary range). Looks like the refinement options are created in realtime since minor keywords load fast too.</p>
  
  <p>Is there a specific SQL technique to create such feature? Or is there a manual on the web explaining the tech behind this?</p>