Possible Duplicate:
Does Oracle support full text search?
I am creating a search website in .net using C#. I am using Oracle 11G for database.
I have a textbox on my home page in which user enters keyword for searching. For searching I am using like operator in Oracle.
As far as I know 'like' have some performance issue When database is large . It is slow. I have heard about 'Full Text search' in MySQL. I want to ask that is there any concept of 'Full Text search' in Oracle. How can I Optimize my searching