Here is a snippet of code from my updates. I am updating a number of views, but this one seems to be giving me a large amount of grief.

I have recently added the set order to hoping that changing to no index might speed up the update, but am not sure.

IF llUpdateOK
SELECT route_problems_vp
cSaveOrder = ORDER()
SET ORDER TO
llUpdateOK = TableUpdate(.T., .T., "route_problems_vp")
IF NOT llUpdateOK
=AERROR(aErrorArray)
=MESSAGEBOX("Update Route Problems Failed" + CHR(13) + STR(aErrorArray(1)) ;
+ CHR(13) + aErrorArray(2))
ENDIF
IF NOT EMPTY(cSaveOrder)
SET ORDER TO &cSaveOrder IN route_problems_vp
ENDIF
ENDIF

The indexes on the table are:

PK (primary)
location_id+depot_code+DTOC(delivery_date)+route_number+load_number+STR(stop_number,5)+customer_number+order_number+product_code+how_requested
not deleted()

location (regular)
location_id

primary (regular)
location_id+depot_code+DTOC(delivery_date)+route_number+load_number+STR(stop_number,5)+customer_number+order_number+product_code+how_requested

I have the following indexes on the parameterized view

PK
location_id + depot_code + DTOC(delivery_date) + route_number +
load_number + STR(stop_number,5) + customer_number + order_number +
product_code + how_requested

location
location_id

depot
depot_code

What do you mean by "Is there an index available to support the subset of records you are updating?"?

Jason