RE: RE: Dead slow count(*)
- From: Nikhil Khimani <nkhimani@xxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Feb 2004 17:14:58 -0500
L&G,
Is there a URL for "Known Oracle Myth?"
Sometimes, it's difficult to argue with an individual when he/she feeds you
the bs with a passion and by the time you learned the myth, it's too late to
bark back :-(
Thanks,
Nikhil Khimani
Market Axess
140 Broadway, 42nd Floor
New York, NY 10005
(212) 813-6230 (W)
nkhimani@xxxxxxxxxxxxxxx
-----Original Message-----
From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx]
Sent: Monday, February 09, 2004 4:59 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: RE: Dead slow count(*)
number of extents does not matter in a query. common myth. I think there is
a paper from about 5 years ago with common myths in it and that was one of
them. Could be wrong.
high water only matters if your not using an index.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
