title: N1ql taking long time to execute
body: <pre><code>SELECT a.*, META(a).id FROM `pricing_qa_2` AS a
  WHERE a.dtype = "qqcfxspd"  AND  1 = 1
  ORDER BY LOWER(a.sch_name) ASC, a.aud_info.ts DESC  OFFSET 0 limit 24
  </code></pre>
  
  <p>Above query is taking long time to execute can you suggest apt index for this query.</p>