Different query plans and performance for same sql query
Hi,
I am running a simple select query with where clause. Where clause has three columns. A composite index is exist against the columns in where clause.
Problem is this if i run this query through SQL developer it is taking 0.01 mili sec to run.
But when i run this query through other editor like Toad or run through JDBC it is taking about 172 - 180 mili sec.
Both hitting the same index but showing different query plans. The cost when run through sql developer is less too.
For JDBC/Toad plan is using
INDEX SKIP SCAN
Predicate Information (identified by operation id):