I have created an INDEX on my tables using below DDL:
CREATE INDEX my_index ON my_table (col1, col2, col3 , EVENT DESC) INCLUDE (col4 , col5);
However the EVENT column is not sorted in descending order. Is there anything I am missing? Have I created the Index correctly?
One thing I wanted to highlight was my EVENT column datatype is VARCHAR....is that making EVENT column not to sort?