Re: Creating Logicals before or after populating a file ?

[Pete Hall <peteh@xxxxxxxxxx>]

At 20:08 10/14/1998 , Evan Harris wrote:
>
>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 ?

At least without SMP, it's always more efficient to create a new access path 
than it is to insert all of the keys into an existing one. You can expect to 
see an increase in the load rate of several hundred percent. 



Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

+---
| 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
+---