my $sth = $dbh->prepare ("select * from big_table order by key");
$sth->execute; # Will find the execution plan
while (my $row = $sth->fetch) { # first row returned immediate
    # do something
    }