Hi, I have a requirement in which I want the event column to be indexed. However I wanted to know if it is possible to ORDER the event column in Descending order something like below:
CREATE INDEX my_index ON my_table (EVENT ORDER BY DESC) INCLUDE (v2);
My Base table has EVENT column but it is not ordered, I am thinking if indexing EVENT column in Descending order will have me get away with the ORDERBY clause and reduce query time.
Request for comments.