title: Can the index (A, B) be used in ORDER BY A for WHERE A > const AND B = const. AND c > const
body: <p>I have the following query:</p>
  
  <pre><code>SELECT (..) FROM db WHERE A &gt; const. AND B = const. AND C &gt; const. ORDER BY A DESC LIMIT const.
  </code></pre>
  
  <p>I definitely need a multi column index (A, B) as the A filter is not strong enough. But can this index be used in the <code>ORDER BY A</code> statement or does this need a (A, B, C) index?</p>