cancel
Showing results for 
Search instead for 
Did you mean: 

Query Plan showing two Query plans

KHK
Partner
Partner

Hi,

I have joined 3 tables and pulling data from these tables. In Query plan it i is showing qurey 1 and query 2 for data .Could you please let me know the reason?

Joining tables like A-->B-->C. I am using aggregated table for data. 

1 REPLY 1

RADSr
Partner
Partner

It looks like Incorta is doing a stitch query and combining results and whatever measure you are getting from the second query is not being broken out by the dimension ( parent ) 

You might be able to set the base table on that measure ( if that is what is happening ) or a redesign of the joins might be in order. 

 

Based on the word doc it might be a simple setting of the base table