Is it really neccessary to say "if you want the right result" in every posting?
So, the answer to every tuning question is:
SELECT 1 FROM DUAL;
It's very fast, there's no disk activity and it's the shortest select statement I can think of.
On the other hand it might not be the result you want!





Reply With Quote