• Its a true Prepared Statement with only one parameter (@P0) as BigInt type...when I've asked in the past, the Developer states that
    I could try putting in an STP, but I'd really like to figure out why this and one other query from this system behave this way.  Certainly no blocking going on and the behavior is very consistent.  The Wait Type is SOS Scheduler Yield when its running the whole time. 
    I believe the developer said that the prepared statement is done by the Driver as a setting.  I'll see if I can get the session settings.

    Just weird it runs in 1 second  via SSMS as normal, without initiating the st prepare and st execute

    Thanks