Query Plan showing two Query plans
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2023 09:03 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2023 09:53 AM
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
