Query when adding a work order.

João Antonio

• December 08, 2021 11:49
• Edited

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

 

Vote

0

• 

  Martin Heigl

  • December 08, 2021 13:04

  Hi, 

  I will check this

  regards Martin
• 

  João Antonio

  • January 24, 2022 14:56

  Hi Martin

  I managed to analyze the case

  regards João
• 

  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

Please sign in to leave a comment.