What is full table scan?.
What actuallt it will do?.
If I say
Select * from table1
Is that it is doing full table scan?.Here it got to read each datablock which had stored any of the rows from table1.