Re: Indexes

[Paul DuBois]

At 6:01 AM -0500 9/19/99, Bill Koob wrote:
>Just curious I created an index using ALTER
>on a single 10 character field - it took
>6 1/2 hours on a 800Meg table with 10+ million
>records. 100 Pentium.  All seems to work
>very well (just very slow).
>
>Qestion: Would it have saved a significant
>amount of time had I created the index at
>the time I created the table and before
>loading the data?
>
>Thanks for any response,
>bill koob

No, normally creating the index in one shot is much
faster than modifying the index for each INSERT
operation.

--
Paul DuBois, paul@stripped