Try to execute the procedure without using 'dbo.ConvertTimeZoneFromUTC'. Table 'PartnerPlayer' is missing an index. (Missing a Primary key, there Should be). You can also use NOT EXISTS instead of Left Outer Join.