How to fix the Oracle error DRG-10847: catsearch requires prefix index for this type of query?

In this post, you’ll learn more about the Oracle ErrorDRG-10847: catsearch requires prefix index for this type of query with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-10847: catsearch requires prefix index for this type of query

Reason for the Error DRG-10847: catsearch requires prefix index for this type of query

Cause: For efficient execution of this Vgram query, we require presence of a prefix index.

How to fix the Error DRG-10847: catsearch requires prefix index for this type of query ?

You can fix this error in Oracle by following the below steps

Action: create a prefix index