• ChrisM@Work (3/19/2013)


    DDL for the table and all indexes, and the actual plans for both queries, would help diagnosis.

    An index on sessionid including status and rsn may solve the problem.

    Will grab this info