Fix Error in CONTAINS for Oracle Text Search, DRG-51030: wildcard query expansion resulted in too ma

Hi

we have a SQL query being done by a customer of ours that is causing the above error:

where CONTAINS(COLUMN,'PROJECT AND LEVEL AND 5%',1)  > 0

The problem we know comes from the fact that 5 combinations is being tokened 120000 times.

Now i understand if they did just 5% as a Text Search they should expect this error but using LIKE instead we have found 90 rows returned from the index table

is the any way of telling the contains to combine all these in one token lookup to avoid the error?

problem i fear is changing the wildcard_maxterms to 0 meaning unlimited for token lookup but then when you read this  warning as well it makes you nervous: