combining multiple Select statements
I'm trying to understand how webi behaves in a situation like this:
- universe with contexts
- query in webi uses objects from both contexts
- so one query would generate 2 Select statements -> normal behaviour so far.
How are the 2 Select statements combined?
- Does webi send each Select separately to the db and then the db handles the combination of queries?
- Or does webi send a combined query (Select 1 + Select 2) to the db? In that case, how does webi combine the query (union, intersection)?
Many thanks in advance,