Below query is taking more than one minute to give result.IS there any way we can tune. I have one index on dtype. Please suggest if need to create any other index.
SELECT a.*, META(a).id FROM
pricing_qa_2 AS a WHERE a.dtype = “qqcfxspd” AND 1 = 1
ORDER BY LOWER(sch_name) ASC, aud_info.ts DESC OFFSET 0 limit 24