title: Slow performance on view index
body: <p>I am trying to find the maximum value of an indexed value but getting very slow performance (over 15 minutes, bucket size >42M items, 100% resident). The index was created with </p>
  
  <pre><code>CREATE INDEX by_name ON sample(name) USING VIEW;
  </code></pre>
  
  <p>And queried by:</p>
  
  <pre><code>SELECT MAX(name) AS device FROM sample USE INDEX (by_name USING VIEW);
  </code></pre>
  
  <p>What can I do to increase performance?</p>