• Thanks Ian, we would have to look at a plan guide as the app is a 3rd party content management system and cannot be changed.

    Now this is all new to me, so what statement would you put in the plan guide, the insert or the select or would you create two guides?

    The rest is pretty self explanitory, Scope = SQL, Hints = OPTION (MAXDOP 1), Batch = NULL, Params = NULL

    Thanks

    Ant