problem about oracle-text-Collection of common programming errors

• 
  Petr Mensik
  sql oracle oracle10g oracle-text
  Is there any performance difference between dbms_lob.instr and contains or am I doing something wrong?Here is my codeSELECT DISTINCT ha.HRE_A_ID, ha.HRE_A_FIRSTNAME, ha.HRE_A_SURNAME, ha.HRE_A_CITY, ha.HRE_A_EMAIL, ha.HRE_A_PHONE_MOBIL FROM HRE_APPLICANT ha WHERE ha.HRE_A_STATUS_ID=1 AND ha.HRE_A_CURRENT_STATUS_ID <= ‘7’ AND ((DBMS_LOB.INSTR(hre_a_for_search,’java’) > 0) OR EXISTS (SELECT 1 FROM gob_attachment, gob_table WHERE hre_a_id=gob_a_record_id AND gob_a_table_id = gob_t_id AN

Web site is in building