Re: ALTER TABLE z ADD INDEX... Speed: Follow up to LEFT JOIN question

2003-10-15 Thread Dan Hansen
- 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 &

Re: ALTER TABLE z ADD INDEX... Speed: Follow up to LEFT JOIN question

2003-10-15 Thread Matt W
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 &

ALTER TABLE z ADD INDEX... Speed: Follow up to LEFT JOIN question

2003-10-15 Thread D. R. Hansen
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