RE: RE: Dead slow count(*)

From: Nikhil Khimani <nkhimani_at_marketaxess.com>
Date: Mon, 9 Feb 2004 17:14:58 -0500
Message-Id: <E90A659E3A7D344C9160B335D51232300EB27DF5@sunvalley.marketaxess.com>

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_at_marketaxess.com

-----Original Message-----

From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net] Sent: Monday, February 09, 2004 4:59 PM
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Mon Feb 09 2004 - 16:14:58 CST