On Mon, 1 Jul 2002, Poonam P wrote:

So this means that there is no way to directly call a record based on it location....

no, no way.

Then is putting an index number to every record a better option as suggested by another person on the list... ie. have an additional column called NO. and can locate this no.

yes, that's the only option.

I'm not much of a database expert (in fact I don't like databases at all), but I think they use some sort of a hash based system to store data (or is that only for the indexes).

anyone who knows datastructures will tell you that you use hashes for key based access, and arrays for record number (array index) based access.