Thanks, adding the indexes worked beautifully. I'll go knock my head on
the desk now. Thanks for your time :)
Ed
Edward Ritter said the following on 7/20/2004 1:08 PM:
Thanks, I'll take a look at that. The id isn't unique, so that's why I
added the idx column.
Does my qu
d:
ALTER TABLE la_entire
ADD INDEX idx_email_address (email_address);
ALTER TABLE la_final
ADD INDEX idx_email_address (email_address);
See:
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
On Tue, 2004-07-20 at 09:22, Edward Ritter wrote:
Stefan:
I added an index column t
help?
Ed
Stefan Kuhn said the following on 7/20/2004 12:05 PM:
I would expect that the speed problems are due to missing indices. Did you do
proper indexing? If unsure, post your table structures and query.
Stefan
Am Tuesday 20 July 2004 17:45 schrieb Edward Ritter:
I've got a task that'
I've got a task that's gonna require me to compare one table to another
and remove the rows from the first table that are found in the second
table that match email_address.
I'm running 4.0.20a-nt-log. The first table has 10 colomns and about 50K
records, and the second table has 46 columns and