Select Col1,Col2 ( Select Col1,Date1 from Table1 UNION ALL Select Col1,Date1 from Table2 ) WHERE COl1 > date - 4 And Col1 < date + 2 Orderby Col1 Desc The above query performance is too slow.When we add the Where condition the query gets slow.Is any other way we can perform the above query.I...