Re: Pros/cons of using as many table partitions as possible
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 20 Apr 2008 07:38:24 +0100
Message-ID: <2-KdnVV3Itt9eZfVnZ2dnUVZ8vCdnZ2d@bt.com>
> Jonathan mentioned here a few years ago
> about using thousands of partitions
> in a table without any major problems.
Date: Sun, 20 Apr 2008 07:38:24 +0100
Message-ID: <2-KdnVV3Itt9eZfVnZ2dnUVZ8vCdnZ2d@bt.com>
- Original Message ----- From: "Noons" <wizofoz2k_at_yahoo.com.au> Newsgroups: comp.databases.oracle.server Sent: Saturday, April 19, 2008 4:15 PM Subject: Re: Pros/cons of using as many table partitions as possible
>
> Jonathan mentioned here a few years ago
> about using thousands of partitions
> in a table without any major problems.
I'm not sure that I did - possibly around a couple of thousand, like one partition per day for 7 years of data, and then be careful about the number of (local) indexes.
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Sun Apr 20 2008 - 01:38:24 CDT