so,
is that only when I say
Select * from , full table scan will be done?
OR
As my openion goes if I say
Select * from where ,
then also all the rows (data blocks to be checked) got be read to decide whether corresponding row meets the WHERE condition in the select statement or not.

Is not it we always do full table scan?