SQL Performance (MOSC)

MOSC Banner

Queries on qualified table name performs better than unqualified tablename

edited May 19, 2018 10:06AM in SQL Performance (MOSC) 14 commentsAnswered ✓

I have a discovered a problem with a query against a local table and am trying to understand why it behaves this way.

I am logged into the schema and querying a table in the schema. Nothing fancy going on here. But look at the difference in the response times of the query if I qualify the table name with the schema name compared to the query without the qualifying schema name. For some reason non-qualified references force physical reads. (Note that the "recipientemail" column is indexed).

scott@DEV> select * from scott.recipient where recipientemail = 'x';

no rows selected

Elapsed: 00:00:00.17

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