Avatar

Community Advisor

Hi J-Serge,

this is just awesome answer. Well, mentioned JS cnx.query lasts 22 min 39 seconds on my instance. Regarding Broadlog table, it has ~264.000.000 records.

Therefore, why I have execution for 1,5 hour? If you are sure this is caused by expensive query, is there a better way to optimize it?

Regards,

Milan