Re: Rules slower than Dynamic SQL ?

On Mon, 2007-11-26 at 16:01 -0800, Alex Vinogradovs wrote:

> I've got a data warehouse with pretty high rate of insert into
> partitioned tables. What I've noticed, is that rule-based partitioning
> seems to be somewhat slower than insertions made directly into
> partitions through execution of dynamic SQL.
>
> Is it really true ?

Depends how complex your rules are, but I think yes is the short answer.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com