Message Oracle DRG-10844 - index cannot execute this structured predicate efficiently

ERRORindex cannot execute this structured predicate efficiently
CAUSEYou specified a combination of condition and order by columns in a catsearch query which cannot be executed by the indexs index set efficiently
ACTIONNone