Performance issue in prepared statement with sql function "LIKE"
843859Jun 15 2006 — edited Jan 20 2015I tried to execute query with sql function Like. I used prepared statement. Driver : oracle.jdbc.driver.OracleDriver. Same query runs fine when I run in TOAD or SqlPlus. Could anyone help me and tell me is there any problem in prepared statement?
Normal query works fine with Like, but problem is happening when it involes sub query too. When I replaced "like" with "=" it works fine. With "=" it takes 50 msec and with "Like" it takes 2 minute.