Recommend optimal composite B-tree index column ordering (equality predicates first, then sort/range columns) and CREATE INDEX DDL.