SQL Performance (MOSC)

MOSC Banner

View Slows Down When Selection Criteria is Used

edited Nov 10, 2013 5:09PM in SQL Performance (MOSC) 17 commentsAnswered
We have a view that returns with results very fast when executed without any selection criteria

       select * from our_vw;

However, when we add the selection criteria it runs significantly slower; from a second or two to several minutes.

        select * from our_vw where cpsid = :B1;

Does anyone have an idea on why this is happening? 

We recently upgraded from 9i database to 11g database and have run an explain plan on the view's query and it all looks OK.  It us just when we try to use the view where the issue is occurring.

thanks

Alan

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