Re: partiioning option not worth it?

Stefan <sroesch3_at_attbi.com> wrote in message news:mP3d8.6609$Iw.14214_at_rwcrnsc51.ops.asp.att.net...

> In DW environments it is mandatory.

That's what the salesman wants you to think!

> How will you implement the sliding window technique without support from
the
> database.

There is (effectively) no difference in this regard between partitioning and building N tables.

> How will you implement automatic partition pruning?
It's not automatic, but I can do it "manually" for less than £40,000 and that's the saving on only one server.

> How will you implement parallel DML? and so on....
Again, I don't see this a particularly difficult process.

> To conclude that. In DW environments it makes sense to spend that money
It MAY make sense - but as I've said before, the cost/benefit calculation is rarely done.

> you also get further features with the enterprise edition which are needed
> in these environments.

and these would be? Received on Thu Feb 21 2002 - 14:21:56 CST