|
Posted by Serge Rielau on 04/13/06 15:43
DA Morgan wrote:
> That's what I've done. I've never seen it. But running SELECT 1 may be
> more of a test of how clueless the person doing the test is than of the
> hardware and operating system. As the two events are not at all similar
> in what they do.
Rating high on the cluelessness on SELECT 1 myself, would you care to
elaborate?
My working hypothesis is that SELECT 1 returns a result set of one row
and one column to the client.
So does SELECT 1 FROM DUAL, AFAIK.
If you are alluding to the fact that Oracle may actually do a table
lookup on DUAL then that could hardly be the competitions fault and you
would be free to supply a better approach for how to return a result set
without driving IO.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Navigation:
[Reply to this message]
|