Query Plan showing two Query plans

KHK — Mon, 03 Jul 2023 16:03:37 GMT

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.

Re: Query Plan showing two Query plans

RADSr — Mon, 03 Jul 2023 16:53:15 GMT

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

topic Query Plan showing two Query plans in Data & Schema Discussions

Query Plan showing two Query plans

Re: Query Plan showing two Query plans