Database Administration (MOSC)

MOSC Banner

Function in View

edited Jul 15, 2009 10:18AM in Database Administration (MOSC) 8 commentsAnswered
On 9.2.0.8 database, I have a view that another DBA developed with one of our developers that contains a function.  This function has some selects that hit the same table as the view uses, which has 150,000 rows.  When I select data through the view, it takes a long time and calls the function for every row in the table.  When I select using the sql of the view directly to the table, it runs in < 1 second and pulls the same rows, only calling the function for the filtered rows, and returned amount of rows is around 300.  Is it normal operation of

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