How to optimize fetching multiple records from a table

A lot of times you would want to lookup multiple records from a table. Would you do that one at a time or is there a better way to do it?

The post How to optimize fetching multiple records from a table appeared first on Hardit Bhatia: The Power Addict.