Channels
accounting
administration
advancedpdf
announcements
arm
australia
beginners
beta-testers
bundles
case-management
content-alerts
crm-sfa
csvimports
data-privacy
defects
demandplanning
dev-ops
fixed-assets-mgmt
formulas
general
integrations
inventory
italy
jobs
manufacturing
marketing
migration-discussion
multibook
nspb
oneworld
order-to-cash
payroll
performance
procure-to-pay
projects
r-e-networks
random
releases
request-a-channel
scis
scripting
sdf
sfa
sitebuilder
spain
srp
suite-app
suite-billing
suite-people
suiteanalytics
suitebuilder
suitecommerce
suiteflow
suiteql
suitescript
suitetalkapi
suiteworld
taxes
training
upvote-enhancements
women-in-netsuite
Title
s
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
Ignore this, the issue was the transactionbillingaddress table - maybe this isn't indexed as left joining to it causes it to slow....