title: can not use sorted index in join query
body: <p>I have a query:</p>
  
  <pre><code>SELECT pr."productId" FROM "ProductRecord" pr
  INNER JOIN "ProductCategory" pc on pr."productId" = pc."productId"
  WHERE pc."category" = ? AND pc."language" = ?
  ORDER BY pr."dailyRock" DESC `
  </code></pre>
  
  <p>There is a descending ordered index on field dailyRock but since productId index is used on join the sorted index can not be used and everytime the aggregated result is needed to be sorted. </p>
  
  <p>Can I force ignite to use both productId index and dailyRock index of ProductRecord table in the query above? </p>