Forum OpenACS Q&A: Re: get sqlplus to send rows to /dev/null ?

Collapse
Posted by Andrew Grumet on
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.