Re: Creating Logicals before or after populating a file ?

["Bill" <bill_meecham@xxxxxxxxxxxxx>]

Isn't there also a run-time performance advantage
to building logicals in an order that is based on
the keys involved?  Something about shared
indexes?

I've been practicing this but don't recall the
reason, stinking aging problem again!

Bill.



-----Original Message-----
From: Evan Harris <spanner@ihug.co.nz>
To: midrange-l@midrange.com
<midrange-l@midrange.com>
Date: Wednesday, October 14, 1998 9:55 PM
Subject: Creating Logicals before or after
populating a file ?


>
>We are about to embark on an exercise that will
populate a *large*
>database file (40 million records plus). This
file has about 20 logical
>files built over it.
>
>My question is, which is more efficient:
>
>1. Populating the file and building the logicals
?
>
>2. Building the logicals and populating the file
?
>
>Any thoughts would be greatly appreciated.
>
>Cheers,
>Evan Harris
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to
MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to
MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list
owner/operator: david@midrange.com
>+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---