Indexes

[Bill Koob]

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