• Missed what is the suposed correct answer. Got confused - I looked at the execution plan ... did NOT consider the message tab as part of the execution plan .

    If one looks at the actual estimated execution plan for a statement such as Select * FROM tablex there is a line entry for "estimated number of rows". For the code in the QOD there is NO such entry.

    So can someone tell me when the message block became part of the estimated execution plan.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]