QuestionQ55Verified/Scripting and AutomationCopy linkReport a problemAsk AstroTutorSave questionHow should a developer optimize a query activity that is currently timing out?AUse intermediate tables to stage dataBUse intrinsic functions in the WHERE clauseCUse SELECT * to include all fieldsShow AnswerAnswerExplanationStaging data in intermediate tables splits a complex operation into smaller steps and reduces the volume of data processed at each stage. Salesforce recommends carrying only necessary fields through successive query activities and joining the final results back to the original dataset, reducing storage and retrieval resources.Learn moreOptimize API Calls and Data Structures to Improve PerformanceShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion