-
From: "D. R. Hansen"
Sent: Wednesday, October 15, 2003 3:39 PM
Subject: ALTER TABLE z ADD INDEX... Speed: Follow up to LEFT JOIN
question
> What amount of time is reasonable to expect for indexing an FK int
field on
> a simple table with about 30K records. It's running on my &
CPU or disk activity (and it's not from other things...),
then it's not hung. Just sit and wait. :-)
Matt
- Original Message -
From: "D. R. Hansen"
Sent: Wednesday, October 15, 2003 3:39 PM
Subject: ALTER TABLE z ADD INDEX... Speed: Follow up to LEFT JOIN
question
&
What amount of time is reasonable to expect for indexing an FK int field on
a simple table with about 30K records. It's running on my "learning"
machine -- an aging Pentium 5/133 box running RH 8 which is ordinarily
quite fast enough for my purposes. It's been running about six hours now,
and