Re: question ???

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 28 Sep 2001 15:05:39 +0100
Message-ID: <A43AA78C3F9DD511AAB100805FBE740D46EF39@lnewton.leeds.lfs.co.uk>

-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk] Posted At: Friday, September 28, 2001 10:12 AM Posted To: server
Conversation: question ???
Subject: Re: question ???

<SNIP>
> From a purely pragmatic point of view, though: if you are building
> very large data sets, and hope to use partitioning, and partition
> pruning in particular, for the performance benefits, then you are
> likely to run into a problem if you use a meaningless key on the
> partitioned tables.

Or, your designers have chosen the wrong data to partition on - as ours did :o(

Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com
------------------------------------------------------------------------

Received on Fri Sep 28 2001 - 09:05:39 CDT