SQL Performance (MOSC)

MOSC Banner

Different query plans and performance for same sql query

edited Feb 7, 2017 4:00AM in SQL Performance (MOSC) 2 commentsAnswered

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):

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center