From oracle-l-bounce@freelists.org Thu Sep 2 18:24:27 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i82NORn08626 for ; Thu, 2 Sep 2004 18:24:27 -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 i82NOQI08620 for ; Thu, 2 Sep 2004 18:24:26 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 501CD72E453; Thu, 2 Sep 2004 15:58:04 -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 21882-28; Thu, 2 Sep 2004 15:58:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CD23E7303F5; Thu, 2 Sep 2004 13:00:18 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 02 Sep 2004 12:58:08 -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 CA67472FD38 for ; Thu, 2 Sep 2004 11:16:16 -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 09149-41 for ; Thu, 2 Sep 2004 11:16:16 -0500 (EST) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.195]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3CE6E72F5A5 for ; Thu, 2 Sep 2004 10:17:46 -0500 (EST) Received: by mproxy.gmail.com with SMTP id 74so321752rnl for ; Thu, 02 Sep 2004 08:20:58 -0700 (PDT) Received: by 10.38.88.12 with SMTP id l12mr591686rnb; Thu, 02 Sep 2004 08:20:58 -0700 (PDT) Received: by 10.38.76.43 with HTTP; Thu, 2 Sep 2004 08:20:58 -0700 (PDT) Message-ID: <9177895d04090208207368b7bc@mail.gmail.com> Date: Thu, 2 Sep 2004 11:20:58 -0400 From: rjamya To: Oracle Discussion List Subject: Count(*) not doing a FTS?? Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 8962 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjamya@gmail.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I am sitting in a class and instructor told us that count(*) reads rowcount from segment header in some (or most?) cases rather than doign the good ol' FTS. He can't remember exact details, so this email .... is it true? Which version was this introduced? Someone has a reproducible test case? Thanks in advance Raj ------------------------------ --- To unsubscribe - mailto:oracle-l-request@freelists.org&subject=unsubscribe To read recent messages - http://freelists.org/archives/oracle-l/09-2004