Hi. Has anyone experienced any slow down in query ...
# suiteqls
Sam L
11/10/2021, 2:26 PMHi. Has anyone experienced any slow down in query time when using LISTAGG in a subquery? I am using it to aggregate line numbers into a single field - but it's taking about a minute to run on 2 transactions. If I change it to count the lines instead, it takes under a second
Sam L
11/10/2021, 2:36 PMIgnore this, the issue was the transactionbillingaddress table - maybe this isn't indexed as left joining to it causes it to slow....