"select *" command will fetch every thing from the given table.
select the "acual execution plan " option to see how sql optimizer is fetching data.means which index or which operator is being used.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)