Please try this. This is just a basic definition

Use <Db_name>

Go

CREATE CLUSTERED INDEX CIX_Job_Id_Property_id

ON [dbo].[Valuation_Common]( job_id, property_id);

GO

Thank You,

Best Regards,

SQLBuddy