Re: horizontal sharding

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.