Query when adding a work order.

Edited December 08, 2021 11:49
3 comments

Hi Martin.

Every time you add a work order or system, look up below.
select "BELNR_ID", "BELPOS_ID", "POS_ID", "NUMMER" from "BEAS_FTSTL" where coalesce ("NUMMER", 0) = 0 ordered by "BELNR_ID", "BELPOS_ID", "SortId"

As we can see where it costs an implicit data conversation or database does not use the index to apply the filter, scanning the entire table and generating slowness, according to my monitoring, this query runs more than 1500 times a day.

Suggestion is to remove this coalesce

The comparison follows, today there are several conversions in the system in this way that impacts the system's performance on all customers.

Regards

João Antonio

Comments

3 comments

Martin Heigl
- December 08, 2021 13:04
Hi,

I will check this

regards Martin

0
João Antonio
- January 24, 2022 14:56
Hi Martin

I managed to analyze the case

regards João

0
João Antonio
- June 27, 2022 11:35
Hi Martin

Have you analyzed this case?

Below is the number of times this query was executed in just one day.

The query could be like this without changing the information

Regards

João

0

Please sign in to leave a comment.