Jim Mlodgenski wrote:
>
>
> also is it possible to paritition without changing client code
>
> Yes, but it depends on the SQL in your client code. If you are just
> using simple SQL with no stored functions, you should be able to slip
> in either solution without changing the client code.
>
what about queries that need to do joins or aggregate reporting across
the partitions?!? I can't see how that could be done transparently
short of something like Oracle RAC.