2 ms·
My "out-of-my-ass" answer would be: My layman's understanding is that indexes are separated data structures with generally fixed size copies of one or more spe
by kbenson 9y ago
My "out-of-my-ass" answer would be:
My layman's understanding is that indexes are separated data structures with generally fixed size copies of one or more specific fields from the main record sorted to allow efficient searching, that contain offsets into the main record store. That is, it allows you to use that field to find records and index into the main set of data. That said, this is how I have inferred it works, and how I would initially attempt to create a database, given little or no knowledge of the field and not allowed to research.