I have some confusion about how composite indexes are working in oracle.
I have a big table with lot of columns including two main columns: ACTIONDATE (Date) and STATUS(char)
STATUS column can have only 3 values.
I have a composite index (ACTIONDATE,STATUS)- starting with ACTIONDATE.
My query is having a condition of type :