Search

OakieTags

more tags

Who's online

There are currently 0 users and 9 guests online.

Recent comments

Affiliations

Home

Miscellaneous Articles

Improving performance with pipelined table functions

Submitted by abb on Thu, 2010-01-21 23:06

Using pipelined functions as a performance tuning tool. January 2010

Method 4 dynamic sql in pl/sql

Submitted by abb on Sat, 2010-01-09 01:13

Using ANYDATASET and pipelined functions to achieve native Method 4 Dynamic SQL. August 2007

Overcoming the limitations of set row

Submitted by abb on Thu, 2010-01-07 08:46

Techniques to avoid superfluous updates with SET ROW. June 2007

Flexible pipelined functions

Submitted by abb on Thu, 2010-01-07 08:36

Combining pipelined functions, polymorphism and multi-table inserts. August 2007

Tuning pl/sql file i/o

Submitted by abb on Wed, 2010-01-06 19:34

Various techniques for unloading data to flat-file faster. February 2008

Pipelined function issues

Submitted by abb on Wed, 2010-01-06 19:28

A few "gotchas" to be aware of when using pipelined functions. September 2007 (updated May 2008)

Returning with insert..select

Submitted by abb on Wed, 2010-01-06 19:20

A workaround to the unsupported INSERT..SELECT..RETURNING construct. August 2005 (updated May 2009)

Pl/sql functions and cbo costing

Submitted by abb on Wed, 2010-01-06 19:14

Associating statistics with PL/SQL functions for greater CBO accuracy. June 2009

Emulating string-to-table functionality using sql

Submitted by abb on Fri, 2009-12-11 20:48

Turning delimited strings into multiple records without PL/SQL. July 2005 (updated August 2007)

Row-generation without i/o

Submitted by abb on Fri, 2009-12-11 20:48

Methods for generating dummy data without incurring I/O costs. November 2004