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!

Slow Query in Pipelined Function

92182Jul 22 2004 — edited Jul 23 2004

I have written a pipelined function "teamname_split",

when i try to do a select "TEAM_ID","NAME" from table(teamname_split) only need 93 msecs

however when i do the following

select "TEAM_ID","NAME" from table(teamname_split) where name = "everton"

then it need 3 sec, what is the problem ?

why when i added a filter, the result will be so slow?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2004

Added on Jul 22 2004

7 comments

747 views