"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.