Sam L

11/10/2021, 2:26 PM
Hi. 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
Ignore this, the issue was the transactionbillingaddress table - maybe this isn't indexed as left joining to it causes it to slow....