• http://scarydba.wordpress.com/2008/07/01/constant-scan-in-execution-plans/

    Pls find the attached query plan.

    karthik