Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!sn-xit-02!sn-xit-06!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: Limit on number of values for list partition? Date: Mon, 03 Mar 2003 17:58:48 -0800 Organization: EXE Message-ID: <3E640858.18F455BA@exesolutions.com> X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@splish28.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 17 Xref: newsfeed1.easynews.com comp.databases.oracle.server:178338 X-Received-Date: Mon, 03 Mar 2003 18:59:17 MST (news.easynews.com) M2 wrote: > Hi All, > I am thinking of using list based partitioning for a date warehousing > application. In order to have range based partitioning work for me I would > need to have as many as a 1000-2000 values. Would these kinds of numbers > work? Would they be efficient? > > Matt. Go to http://tahiti.oracle.com and search on partitioning. You evidence a need to know a lot about partitions before you consider such activity. Be sure you also explore local versus global indexes. Daniel Morgan