Forum OpenACS Q&A: Re: get sqlplus to send rows to /dev/null ?
6: Re: get sqlplus to send rows to /dev/null ? (response to 1)
Posted by Andrew Grumet on 02/27/04 03:08 PM
Andrew, I don't have an answer about /dev/null, but here's one tactic I sometimes use: replace the fetched column list with a count(*) so that you only get one row back. It's not an exact method, because iirc the query optimizer pays attention to what columns you asked for, but the performance is mostly determined by the stuff that comes after WHERE, which stays the same.