All, Here are 2 best practice question for sequencing queries.
Question 1)
Is it best to create queries off queries so they run in sequence (Flow #1 below) or "Parallel" queries from the same source and then merge them later?
The logic in Union Query 1 & 2 is similar but not the same, and not complex, so (basically) replicating logic in Queries 1 & 2 is not an issue
This is purely a general best practice and speed question.
Flow #1
FLOW #2
Question 2
is it generally better to create a series of "smaller" queries that run in sequence or one "larger" and more complex query?
This is more of a straight question of speed.
As always, thanks. Your help is always appreciated
Question 1)
Is it best to create queries off queries so they run in sequence (Flow #1 below) or "Parallel" queries from the same source and then merge them later?
The logic in Union Query 1 & 2 is similar but not the same, and not complex, so (basically) replicating logic in Queries 1 & 2 is not an issue
This is purely a general best practice and speed question.
Flow #1
FLOW #2
Question 2
is it generally better to create a series of "smaller" queries that run in sequence or one "larger" and more complex query?
This is more of a straight question of speed.
As always, thanks. Your help is always appreciated