I have 2 queries that are exactly the same in structure. They differ only in filter. One has a filter on one value of a column and the second query has a filter on another value of the same column, This would mean that 2 separate queries would be executed
I was thikning of having one main query and the use 2 query references. I will put the filters on the reference query. I am hoping that this would be better for performance. is that so?
If both filters work through an index scan on the database, you will possibly lose selectivity by using your proposed solution. In these cases, why not test both solutions and determine which one is the favourable one..?
It sounds like you can have one query that uses an 'in' filter rather than an 'equal'? Data item in ('value1','value2') instead on Data Item = 'Value1'.
Quote from: bi4u2 on 25 Jun 2012 08:17:01 AM
It sounds like you can have one query that uses an 'in' filter rather than an 'equal'? Data item in ('value1','value2') instead on Data Item = 'Value1'.
True ,if you want all data in 1 datacontainer. If each dataset should be used for a specific container, then this will not work