Hi,

Please see the attached file,

1. execution plan of slow running query in query in production server ( 36 second)

2. execution plan of same query in query in test server ( 2 second only)

3. table structure of the table (PTS), that cause the issue of slowness ( I think so)

4.Index structure of PTS .

Both test and production are same vision of OS and SQL server

Test is a pC, still it is faster.

Please advice, how i can improve the performance

Regards

Mathew