Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FRP - performance method

sgalaxyJul 28 2017 — edited Jul 28 2017

Hi,

the other day i bumped into a method called FRP (filtered row percentage).

http://kirlew.net/oracle/docs/SQLperformanceTuning.pdf

Personally, i find it interesting since it focus on the main idea of sql tuning:

'eliminate as many rows as possible, as soon as possible'.

What's your opinion on this method?

Do you follow it extensively  or at least at the queries which are slow?

Thanks,

Sim

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2017
Added on Jul 28 2017
2 comments
733 views