Database Tuning (MOSC)

MOSC Banner

What should I choose between low logical read and faster execution time

edited Dec 13, 2009 7:08PM in Database Tuning (MOSC) 10 commentsAnswered ✓
 Hi all,

Thank you in advance for reading my quesion.

I am tuning one suboptimal sql and have rewritten the sql in different ways,say them A,B and so on.

A has lower logical reads but longer execution time 7s.

B has higher logical reads but shorter execution time,3~4s.

A and B returns the same result set.

Our department usually buffer_gets/rows_returned to judge one sql good or not.

In this case, should I  choose A or B?

And another doubt.

Let's assume that the criterion is buffer_gets/rows_returned <M

With parameter X, SQL retuns 100rows with about N logical reads. N/100<M

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