Hi Guys,



I have scenario where I need to make "Like" type of search based on
certain type of combinations on multiple million record table. Like for
full name "Ahmed" I need to find all records which have any two
character of this name as "AM/MD" etc. in any order. As per requirement,
I need to build this query dynamically based on type of input. Due to
various combinations included in search I have getting major performance
hit.



Will anybody share his/her experience for this issue. Thanx in advance.



Regards,

Sanjeev


Oracle LazyDBA home page