A little background...

All of the views and functions defined in this database are as-is from Microsoft. This is the Microsoft System Center 2012 Configuration Manager database.

The data...

Thank you...attached.

Edit: I added the DDL for the related objects as scripts.txt

How do I post the execution plan? Do you want me to post the text of it here? I don't see an option to upload it to this...

Yes, I included the execution plan. There is an icon called 'Key Lookup (Clustered)' that accounts for 68% of the cost.

Physical Operation: Key Lookup

Logical Operation: Key Lookup

Actual/Estimated Execution Modes:...

Ditto. Any suggestions?

You may want to download a 30-day trial of Quest Software's Spotlight on SQL Server:

http://www.quest.com/2_0/registration.aspx?requestdefid=69

Provides a visual of various potential bottlenecks in one view and allows you to...

Thanks you, sir.  Will procure the sofware from Microsoft.