ORDER BY O_ord_pay.op_vendor, O_ord_pay.op_ord_dateI am now trying to create a index that should replicate the above sorted order as follows:
INDEX ON op_vendor+dtoc(op_ord_date) TAG (vendorord) ascending SET ORDER TO (vendorord) ascendingWhen I run the second senerio, the order of data doesn't come out like the view order. What I'm I doing wrong?