Query optimisation

[ksarfraz]

Hi Ifor
I created a new thread if you would like to have a look

Query Optimization and Performance Issue

Hi, Production SP is performing very poor and even sometime application is getting timed out. I looked at the SP and found out that query below highlighted in BOLD is the mail cause of concerns. Any chance anyone can look and provide any inputs whats wrong in this query and why its taking huge time. Thanks in advance. (If you want script for whole SP then leave comment and i will paste here) [IndexPageNumber] = ( SELECT TOP 1 NumberOfIndexPages FROM [EditionBrief] INNER JOIN [EditionBrie…