Re: VS: Virtual column partitioning
Date: Mon, 11 Mar 2013 17:09:25 +0000 (GMT)
Message-ID: <alpine.DEB.1.10.1303111508460.25944_at_seq1a.internal.sanger.ac.uk>
Thanks Timo, very useful.
Regards
Karen
On Mon, 11 Mar 2013, Timo Raitalaakso wrote:
>
> Using and working fine.
> Optimizer does partition pruning for queries.
> A slight increased cpu usage while bulk loading data.
>
> --
> Timo Raitalaakso
> http://rafudb.blogspot.com
>
> ---- alkuperäinen viesti ----
> Lähett.: Karen Ambrose
> Lähet.: 11.03.2013, 15:37
> V.ottaja: oracle-l_at_freelists.org
> Aihe: Virtual column partitioning
>
>
> Hi everyone,
>
> Does anyone have experience of using virtual column partitioning in
> Oracle 11.2? If, what are your experiences good or bad and are there any
> caveats that I should be aware of?
>
> Regards
>
> Karen
>
> __________________________________________
>
> Karen Ambrose (kva_at_sanger.ac.uk)
> The Sanger Institute (Cambridge)
> __________________________________________
>
>
> --
> The Wellcome Trust Sanger Institute is operated by Genome Research
> Limited, a charity registered in England with number 1021457 and a
> company registered in England with number 2742969, whose registered
> office is 215 Euston Road, London, NW1 2BE.
> --
> http://www.freelists.org/webpage/oracle-l
>
-- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE. -- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 11 2013 - 18:09:25 CET