Re: Index before or after inserts?

[Ed Leafe]

On Nov 27, 2003, at 10:32 AM, Mirza wrote:

I need to insert hundreds of milions of records to a table and make 
several indicies on it. Now, is it faster to make tables with indicies 
and then fill tables or fill tables first, then make indicies? Any 
experiancies?
	Insert the records first, then index. Otherwise, the indexes have to 
be updated with each and every insert.

     ___/
    /
   __/
  /
 ____/
 Ed Leafe
Linux Love:
unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]