I have a query in which i m using UNION ALL , for eg Query A union all Query B,
if i run query A and B individually, they are running properly but when i am running "Query A union all Query B"
it is giving me AMP Skewness.
Can anyone please tell how UNION ALL works and Why this issue is coming.
Do you mean utlisation of Amps ? or are you talking about final table being skewed in terms of data stored in various vprocs ?