What happens to the application performance if you re-enable (or create?) an index on the ARM_ARTIKEL_NR_DD field on [dbo].[ARTIKELMAGAZIJN] ? You're probably causing a full table scan to find out...