RE: Adding indexes on large tables

2003-10-07 Thread Brad Teale
another drive like Dan, said. Brad -Original Message- From: Brendan J Sherar [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 6:27 AM To: [EMAIL PROTECTED] Subject: Adding indexes on large tables Greetings to all, and thanks for the excellent resource! I have a question regarding

RE: Adding indexes on large tables

2003-10-07 Thread Dan Greene
IL PROTECTED] > Subject: Adding indexes on large tables > > > Greetings to all, and thanks for the excellent resource! > > I have a question regarding indexing large tables (150M+ rows, 2.6G). > > The tables in question have a format like this: > > word_id mediumint uns

Adding indexes on large tables

2003-10-07 Thread Brendan J Sherar
Greetings to all, and thanks for the excellent resource! I have a question regarding indexing large tables (150M+ rows, 2.6G). The tables in question have a format like this: word_id mediumint unsigned doc_id mediumint unsigned Our indexes are as follows: PRIMARY KEY (word_id, doc_id) INDEX (d