Delete indexes before update qry?

  • Thread starter Thread starter Razor
  • Start date Start date
R

Razor

Hi,

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

Thanks,

Razor
 
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?
 
Hi,

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

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).
 
Back
Top