On Tue, 4 Feb 2003, John Smith wrote:
> Think that makes sense ;). However, I just dropped all the foreign key
> constraints on stats and there wasn't any speed increase in the query.
> I've also tried dropping the index on clicks (no speed-up there
> either).
Can you duplicate it with a new table?
Something like:
create table foo as select * from stats;
update foo set clicks=3344;