But, remember - you don't rebuild completely an index - you rather add
to it.
So, there are three scenarios:
1. Q: You create the table to then send into it lots of data row per row
A: create the table first, then build an idex on it once.
2. Q: You have to constantly be adding the data i
> 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?
In the end, i
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-index
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 th
