Thanks .... they haven’t agreed to it... I will have to do some trial and error based on your recommendations

@Erikur,  Sorry, I forgot to ask- is parallel execution worse, how to avoid parallel execution

Sorry, I forgot to ask- is parallel execution worse, how to avoid parallel execution

Hi All,

Thanks for your valuable feedback, I'm working on the query now and hope it will improvise

Thanks

NB

Hi Eric,

Can you advise on this please,

say as in this case the date filter is only passed from the SSRS report, how can I redesign the whole thing. consider that...

Hi Jeff,

It’s a SQL Sentry plan explorer file.

Thanks

NB

Hi Erikur,

The view is actually a datasource for an SSRS report and it has the date from and to filters. So the view is supposed to bring back all the...

Please see a sample script for 3 tables, is there any  area for improvement. I noticed a hash join in the execution plan and was thinking nested join is better...

Thanks all once again..

How can I attach the execution plan

Thanks all for the advise, I'm trying to figure it out by adding few index.

Unfortunately my It don't allow to upload code and hence I'm helpless on that. Is there...

Thanks for your replies. what other information do you need ?

Hi Drew,

Can you advise what changes have to be made to improve performance

Kind Regards

thenewbee

Hi Jonathan,

Not sure I’m greedy but was trying to reduce the execution time from 3 secs to 1 sec. to reduce the logical reads from 5296

Regards

theNewbee

Thanks Chris,
, but some other query utilizes the other column. If thats the case we have to create multiple index for each query right

Regards
bee