Thread

Re: Comparitive UPDATE speed

Josh Berkus <josh@agliodbs.com> — 2002-10-01T23:50:21Z

Randy,

> I'm not sure about 20 times longer but you would have index records
> that 
> would need to be changed.  Is field_3 indexed in all 3 tables?  If
> table_b 
> does not have an index on field_3 and the other tables do, I'd guess
> that 
> would make this take longer too.

Yeah, they're indexed.   I'm going to try the updates without the index
on field_2 tonight.

-Josh Berkus