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
> [EMAIL PROTECTED]
> 
> 
> 
> "Jason Vincent" <[EMAIL PROTECTED]> 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
> 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to