Suggested Indexes on a SQL 2000 DB - Preventing Bookmark Lookups

So I have the following code - written by a 3rd party supplier. Can anyone suggest what indexes should be used to prevent bookmark lookups? Do you need the content of the UDFs as well?

SELECT reportTbl.ReportDBID, 
case when reportTbl.ResultStatus = 'P' then 'PRELIMINARY'  
when reportTbl.ResultStatus = 'I' then 'INTERIM' 
else reportTbl.ResultStatus end   As Status, 1   as isAccessible, 
dbo.repAb(reportTbl.ReportDBID)   As Abnormality, 
dbo.repAb(reportTbl.ReportDBID)   As Importance,   
reportTbl.UniversalServiceDescription as Title,  
reportTbl.DiagnosticServSectID as ServiceDescription, 
case when ResultStatus='X' then 'Cancelled'   when ResultStatus='C' OR dbo.inferStatus(reportTbl.ReportDBID) = 'C' then 'Amended' 
else reportTbl.DiagnosticServSectID   end AS subCategory, 
reportTbl.DiagnosticServSectID as subCategoryAlt,  
case when cdrOth.FamilyName is not null   then cdrOth.FamilyName else cdrOth.IDNumber end As Autho开发者_Python百科r, 
reportTbl.ObservationDateTime 
FROM reportTbl WITH (NOLOCK)
INNER JOIN patientTbl WITH (NOLOCK) ON reportTbl.patID = patientTbl.patID
LEFT OUTER JOIN cdrOth WITH (NOLOCK) ON reportTbl.ordID = cdrOth.SegCrossReferenceDBID 
WHERE
patientTbl.recNumber ='111111111'
and reportTbl.ResultStatus IN ('G', 'H','I', 'J')
and reportTbl.DiagnosticServSectID IN ('E', 'F')
and reportTbl.UniversalServiceCode NOT IN  ('A', 'B', 'C', 'D') -- there are roughly 750 options so using NOT IN is easier
ORDER BY ReportDBID

Bookmark lookups are usually removed by using covering indexes

Some great examples here

This explains it better than I would. But the summary is that columns in the bookmark lookup should be added to the index.