Mirza, Definitely, index after insert.
Andy > -----Original Message----- > From: Mirza [mailto:[EMAIL PROTECTED] > Sent: 27 November 2003 15:33 > To: [EMAIL PROTECTED] > Subject: Index before or after inserts? > > > 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? > > regards, > > mirza > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]