SQL Performance (MOSC)

MOSC Banner

Different explain plan when using synonym?

edited Jun 12, 2015 1:34PM in SQL Performance (MOSC) 13 commentsAnswered

I have a synonym pointing to a table and when directly accessing the table (ap_checks_all) queries return data as expected.  Usng the synonym (ap_checks) no rows are returned.  Looking at the explain plan they both access the ap_check_all table but the synonym has a a 'null is not null' filter predicate.  There are a couple of possible hits which suggest aome alter session workarounds but these do not appear to work.  Has anyone come across this?

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