quote:

---

Originally posted by sk.faheemuddin

Hi,

I am having a query containing three unions.
But i want to compulsory execute 1st query
rest two query should be optional based on the
users interest using parameters
because 2nd and 3rd query are time consuming.

But even though data retrieval point of view
it is working very fine but time taken is same
there is no change

for example

/*Parameter Area*/
declare @StartDate as datetime
set @StartDate ='09-MAY-12'
declare @EndDate as datetime
set @EndDate ='09-MAY-12'
declare @With_MonthYear as nvarchar(1)
set @With_MonthYear ='N'
/*Main Query Area*/

select * from a where a.date betwn @startdate and @enddate;
union all --B
select * from a where a.date betwn @startdate and @enddate
and 'Y'=@With_MonthYear;
union all --C
select * from a where a.date betwn @startdate and @enddate
and 'Y'=@With_MonthYear;

i.eee the 2nd n 3rd should only work when user selects 'Y'
but it execute i guess and take same amount of time
approx..more thn 2mins

Please advice

---