Hi Chris, hi Raj, in relational databases there are different targets for the optimizer: Return the first record as fast as possible, even if reading through the whole dataset takes longer (low latency) Return all rows as fast as possible, even if reading the first record may take a longer time (highest throughput)
Best regards, Jens
