building access path problem

[Guest_imported]

hi guys,

could someone help me please to resolve my probem in access paths.

I SAVE *ALLUSR day ago with access path = NO, after the backup we run one application and the results was not good. so i immediately restore the *ALLUSR.

when i run our current application, in every option the system is always building access path which take much time.

I have the the backup with ACCESS path YES month ago. can i use this to resolve my problem?

Awaiting for your valuable reply.

Henry
MIS, KSA

 

[stevejc]

Yes it will!!! Huge! Little extra time on a save. Lotta saved time on a restore. Don't know why anyone would save with Access Paths *NO.

Regards,

Steve