have a query running sub second on sqlplus and through a test class i generated to use jdbc. however in the application it is taking 20secs and is taking this time once accessing the jdbc method ps.executeQuery(). Other queries (the same query without a predicate being added) runs sub second on the app so i am mighty confused.
Anyone? thanks in advance.
Joined: Aug 02, 2003
Check if the predicate is doing some costly operations on charater field. We can help you more if you can post both the queries.