SQL Performance (MOSC)

MOSC Banner

bad performance on 3 connected queries with counts

edited Feb 27, 2017 2:42PM in SQL Performance (MOSC) 3 commentsAnswered

Hi, could somebody help us with this issue..

We’ve three queries in production and they are run for each search.  The first returns the paged search results.  The second returns a count with security filters applied.  The third returns a count without security filters applied.  If the count in the third query is higher than the second, a message is displayed.  The two count queries are very inefficient as they require scanning of all records on huge tables.  Implementing a fix to remove the display of the count from the search grid eliminates the need for the second query but not the third.  This is why when we

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