It would be nice to be able to have a way to not default "Suppress Duplicate Rows" with Revenue Queries. Any way to control this would be a great feature within CRM to create queries.
Suppress Duplicate Rows negatively impacts performance, sometimes significantly, especially for Selections. For one of our CRM databases, there are 125 nightly static queries that refresh and were created without disabling suppress duplicate rows. Changing that cut the time to refresh them in half. Suppress duplicate rows should be the exception, not the default. For most forms, we could change that - but not for this form.
Suppress Duplicate Rows negatively impacts performance, sometimes significantly, especially for Selections. For one of our CRM databases, there are 125 nightly static queries that refresh and were created without disabling suppress duplicate rows. Changing that cut the time to refresh them in half. Suppress duplicate rows should be the exception, not the default. For most forms, we could change that - but not for this form.