Thankx a lot man.....

It works.....

Thankx once again.

Hi John,

Thankx a lot for the feedback. But if it is so, then in the SP when I am passing the parameters, how is it giving the same query plan?

Hi Ian,

Thankx for the reply. But as I told you, both the databases A & B are having same tables & indexes. Will it still show different Query plans for...

Hi Karl,

Thankx a lot. It worked.

Thanks once again....

U can read the graphical view from left to right & from top to bottom. On each icon, if u point the cursor it will pop-up the results also. For...

Mr Ajit,

Thanks for the reply. I have tried before whatever you have mantioned. It was not working. Any other solution to resolve the above two problems.

I think by using CASE statement you can resolve the issue.