speed reading records from Table

[pvinod]

Hi,

Consider a table have 10,00,000 records.

What is the time difference between reading single record from the table and reading all the records from the table?

which one will be faster?

thanks,
vinod

[debasisdas]

Reading a single record will be obviously faster.
An index can make it even faster.