• table scan....I think it will be index scan....and query 1 will give a index scan...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]