PL/SQL (MOSC)

MOSC Banner

Performance of Difference Table Functions

edited Oct 25, 2013 1:34AM in PL/SQL (MOSC) 1 commentAnswered
We have some views in which CONTRACT_YEAR is harded coded (otherwise filter on CONTRACT_YEAR would not be pushed through because of the complexity of view definition). Now we want the CONTRACT_YEAR to be flexible, so want to replace these views wiht table functions. We are exploring pipelined table functions and regular (non-pipelined) table functions. We saw very different performance of them. Could you advise:

1. Why one is better than the other?

2. Any better solutions than what I have here?

Thank you in advance.

All the four functions do exactly the same thing, but in idfferent ways. The code is simplied.

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