Yes the query is slow and it took around 10-12 second to complete the sql statement. This cause lock to another user process and it slow down the entire system.

Following are the details of one object in execution plan.

Physical Operation : Index scan

Logical operation : index scan

Row count : 1,104,299

Est.Row size :33

I/O cost : .932

cpu cost : .0506

Number of executes : 24

cost : 1.905(4%)

SubTree cost : 1.91

estimate row count : 1,104,299

In processor of SQL Server shows : 24.

My processor is : intel xeon x 5650.(Hyper-Threading Technology)

So can i change "max degree of parallelism" to improve the performance?

Please advice

Regards

Mathew