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
(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/up