Aggregate Reflection is not used with query having join between 2 tables

1

Hi Team , I have Aggregate Reflection created on 2 different source tables . When i execute a query having these 2 source tables with join clause , Aggregate Reflections are not used. However Raw reflection is used. Please let me know if it is possible to accelerate query having join clause using Aggregate Reflection ?

Thanks,
KP

2

Also in the Raw Profile it says considered,matched,not chosen. What could be the reason for not chosen?