From oracle-l-bounce@freelists.org Thu Jul 8 10:14:57 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i68FEWC20782 for ; Thu, 8 Jul 2004 10:14:42 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i68FEM620725 for ; Thu, 8 Jul 2004 10:14:32 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4259B72CDDD; Thu, 8 Jul 2004 09:55:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13484-38; Thu, 8 Jul 2004 09:55:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 847C472CDF0; Thu, 8 Jul 2004 09:55:36 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 08 Jul 2004 09:54:11 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 60EFA72CAA7 for ; Thu, 8 Jul 2004 09:54:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13578-06 for ; Thu, 8 Jul 2004 09:54:10 -0500 (EST) Received: from www.hotsos.com (hotsos.com [209.120.206.15]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D297B72CB07 for ; Thu, 8 Jul 2004 09:54:09 -0500 (EST) Received: from CVMLAP02 (66.169.163.33.ts46v-12.otne2.ftwrth.tx.charter.com [66.169.163.33]) (authenticated (0 bits)) by www.hotsos.com (8.12.11/8.11.0) with ESMTP id i68FI5er011925 for ; Thu, 8 Jul 2004 10:18:06 -0500 From: "Cary Millsap" To: Subject: RE: Difference between count(1) and count(*) Date: Thu, 8 Jul 2004 10:16:32 -0500 Message-ID: <00c501c464fe$9079f900$6701a8c0@CVMLAP02> MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 In-Reply-To: <070820041338.22463.40ED4E3A00016E76000057BF2200734840079D9A00000E09D2020E979D@comcast.net> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4665 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cary.millsap@hotsos.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I think "some reason" is that for decades people didn't know how to = measure performance (that is, response time). How can you possibly know what's = GOING to happen if you can't even tell what DID happen?! Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 7/20 Cleveland, 8/10 Boston, 9/14 San = Francisco - SQL Optimization 101: 7/26 Washington DC, 8/16 Minneapolis, 9/20 = Hartford - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org] On Behalf Of ryan.gaffuri@comcast.net Sent: Thursday, July 08, 2004 8:38 AM To: oracle-l@freelists.org; oracle-l@freelists.org Cc: Tanel P=F5der Subject: Re: Difference between count(1) and count(*) for some reason there appears to be more B.S. associated with = performance tuning than any other Oracle topic. People are far more likely to pull = stuff out of their asses on performance tuning than anywhere else...=20 -------------- Original message --------------=20 > I've actually seen an "expert" optimizing the count() statement, by = using=20 > count(null) "since null means nothing and thus is the fastest" :)=20 >=20 > But check this:=20 >=20 > SQL> select count(*) from dual;=20 >=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------