Urgent:Acceleration is not working as expected

1

Folder - 2017

	2017_A (VDS A is created with 2017 data) - Applied reflection and month partition
	2017_B (VDS A is created with 2017 data) - Applied reflection and month partition

Folder - 2018

	2018_A (VDS B is created with 2017 data) - Applied reflection and month partition
	2018_B (VDS B is created with 2017 data) - Applied reflection and month partition

Since the tables are big there is a spit on years.

Create vds as A
select * from 2017_A
union all
select * from 2017_B

Create vds as B
select * from 2017_A
union all
select * from 2017_B

create vds main
select * from a
union all
select * from b

select * from main where math_id=1405 (Month id 1405 is actually 2017 January month data)

Expected the query is accelerated with all (2017_A VDS )

But its accelerated with all (4 VDS (2017_A/2017_B/2018_A/2018_B)

2

@krajkumar14
can you attache the query profile to look at thee reflections