Re: indexing on existing DB

Except when you have a million records, which may take a few seconds to build. :-) Marco ------------- php|architect -- The Monthly Magazine For PHP Professionals Come visit us on the web at http://www.phparch.com! On Fri, 2002-11-08 at 11:12, Maxim Maletsky wrote: > > Index is always re-indexing itself on INSERT/UPDATE. Roughly, I don't > think there is any difference in when you create an index before or > after table is populated. > > > -- > Maxim Maletsky > maxim@php.net > > > > "Jason Vincent" <jayv@nortelnetworks.com> wrote... : > > > (I know this is more of a mySQL question than PHP, but allow me this one if > > you would...) > > > > In MySQL, is there any difference between creating an index at table > > creation time, and creating an index on an existing table? Does an index > > created on an existing table re-index itself after each insert/update, or > > does it only index itself once - when you create the index? > > > > Thanks in advance > > > > Regards, > > > > J > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >