Re: Huge primary key creation

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 8 Jan 2003 19:38:56 -0000
Message-ID: <3e1c9467_3@mk-nntp-1.news.uk.worldonline.com>

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:8vpo1v4dhf8oe50ubst0ga6qbils6mgn7q_at_4ax.com...
> On 8 Jan 2003 08:08:49 -0800, rickraster_at_hotmail.com (RR) wrote:
>
>
> The temp space needed is roughly 2 times the average length of a key
> times the number of records.
>

Hey, that's a good one. I must confess that (not having - to date - had to deal with more than circa 10m rows) I've never bothered measuring, so that's a rule of thumb I'll adopt, and see how it goes.

Thanks, Sybrand!

Regards,
Paul Received on Wed Jan 08 2003 - 13:38:56 CST