Hi Lowell,

Thanks for your Help guy.

I know if you use a complicated view (it's a case), you can get a crappy plan. Another thing, on view you can't create indexes, is it correct ?

I have to check number of rows used by the table variable and see if it's a good thing to switch to a temp table.

If I saw yours differents tracks, tuning sql server parameters (min memory query 1024 to 2048

and max thread 704 by default to 1024) bring nothing and don't solve my issue. Is it correct ?

Another thing, parameter sniffing could be generated this kind of issue. What do you thing ?

Regards,

Eric