long running query when posting PO invoice - SubledgerJournalTransferCommand.insertGeneralJournalAccountEntryRelated() Update Slow

Symptoms

long running query when posting PO invoice - SubledgerJournalTransferCommand.insertGeneralJournalAccountEntryRelated() Update Slow

Resolution

Break update statements into 2 parts because Or clause is throwing off the SQL optimizer. Updated indexes for further performance optimization

More information

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Svojstva

ID članka: 4013754 - posljednja izmjena: 21. velj 2017. - verzija: 1

Povratne informacije