Optimal way to avoid iterating through each row in a dictionary of data/arrays?

design-patterns architecture algorithms database-design dictionary