Delete indexes before update qry?

[Razor]

Hi,

Will I get better performance in an update query if I
first delete indexes in the target table?

Thanks,

Razor

 

[Van T. Dinh]

If there is any difference, you probably won't even notice it.

OTOH, Indices are set according to your data requirements so I am not sure
why you would you want to delete the Indices when you run an Update Query?

 

[John Vinson]

Hi,

Will I get better performance in an update query if I
first delete indexes in the target table?

Possibly, but not necessarily. If the update query has criteria to
determine which records to update, the index will speed up that part
of the operation, although updating the indexes will slow it down
thereafter.

IME the time taken to drop the indexes (and, often, remove the
relationships to other tables which require the indexes), run the
query, and restore the indexes (and relationships) outweighs any
benefit from the faster update query, but there have been a couple of
cases where it was beneficial (in Oracle, not in Access as it
happens).