Re: partitioning

From: Peter <depend3_at_yahoo.com>
Date: Mon, 28 Oct 2002 13:48:45 GMT
Message-ID: <1fbv9.182689$8o4.29060@afrodite.telenet-ops.be>

"Daud" <daud11_at_hotmail.com> schreef in bericht news:f0bf3cc3.0210280202.1be923bf_at_posting.google.com...
> Someone told me this:
>
> Partitioning has no effect on performance unless the Cost Based
> Optimizer is used.
>
> Is that true? I find it a bit hard to believe but then I am not sure
> since I dont know much about partitioning.
>
> rgds
> Daud

Bullshit. It works very well on tables even when they don't have statstics. You only have to make sur the indexes are partitioned too. Received on Mon Oct 28 2002 - 07:48:45 CST