I have a view that orders the data by following:

 ORDER BY O_ord_pay.op_vendor, O_ord_pay.op_ord_date

I 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) ascending

When I run the second senerio, the order of data doesn't come out like the view order. What I'm I doing wrong?

Thanks
Nick Patel