Re: Oracle partitioning

In article <7v6fj1$bif$1_at_ctb-nnrp1.saix.net>,   "Billy Verreynne" <vslabs_at_onwe.co.za> wrote:
> kachkar_at_my-deja.com wrote in message <7v609f$833$1_at_nnrp1.deja.com>...
>
> >I have some simple questions :
> >How effective is the partitioning ?
>
> As effective as the implementation of it.
>
> >If I implemented it, Is it going to cut down the query time by 100% ?
>
> Very unlikely.
>
> >I would like to here from anybody who used it , and how fast is the
> >performance before and after using the partitioning…
>
> Ah.. this question makes more sense. However, the answer IMHO will
still be
> meaningless with regards to your situation.
>
> There are no hard and fast rules in database systems. There's no magic
wand
> solutions that always work and always provide huge performance
increases.
> There are too many factors that are unique to every situation.
>
> To partition or not to partition can only really be answered by
> investigating the data you want to partition, how these partition
tables are
> to be populated, updated and maintained, what type of queries are run,
and
> so on.
>
> regards,
> Billy
>
>

Billy ,

Let us assume that I've created the ideal environment for the partitioning, again how
effective is the partitioning ?

Regards,
Khaled Achkar

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 27 1999 - 18:37:32 CDT