We need to fuzzy search on table which have 20 million records and its will be growing continuosly adding 20K records each day. Our application is J2EE env where we make a jndi call to database and run the queries.
Fuzzy search query what we have is the below query which search for similar EO_Short_Name like TestName and returns, as it scans entire table its taking very long time to retrieve records from 20Million TR_Details table.
FROM pp.TR_DETAILS TDMESSAGE
UPPER(TDMESSAGE.EO_SHORT_NAME) LIKE '%TestName%'
Can someone advice the approach what we can follow to resolve the above issue for big data..
thanks in advance
This forum, as the title says, is for Sql Developer questions only and NOT for Sql or PL/SQL questions.
Mark the thread answered and repost it in the SQL and PL/SQL forum.
Before you repost you should RTFM about the Oracle Text functionality. It is designed for text searching.