A few possibilities come to mind including network traffic & cache. If
you ask the question in remote TOAD (or remote SQL*Plus) and then ask it
from the SQL*Plus locally, you might find the 'question' and possibly
the 'answer' is still in memory. Have you tried asking twice from TOAD
in quick succession? Is there a difference in timing?
As an aside, did you really mean to form the Select like that? Is there
a reason for 1) retrieving all info, 2) ordering and 3) passing the
result set to 'count(*)'? (Not criticizing, just curious)
/H
Received on Tue Mar 25 2003 - 14:27:46 CST
