Xref: alice comp.databases.oracle.server:36869
Path: alice!news-feed.fnsi.net!news.idt.net!news-peer.gip.net!news.gsl.net!gip.net!newsfeed.cwix.com!204.238.120.130!news-feeds.jump.net!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: mgogala@rocketmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Any way to get RowCount by not using Select count(*) from table
Date: Sat, 02 Jan 1999 01:31:11 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 34
Message-ID: <76jst0$ln9$1@nnrp1.dejanews.com>
References: <75ugnl$2jt$1@remarQ.com> <368957E5.E61F829@miname.com> <368a8bd8.10556391@news.siol.net>
X-Article-Creation-Date: Sat Jan 02 01:31:11 1999 GMT
X-Http-User-Agent: Mozilla/4.5 [en] (X11; I; SunOS 5.6 i86pc)
X-Http-Proxy: 1.0 x13.dejanews.com:80 (Squid/1.1.22) for client 38.26.182.24

In article <368a8bd8.10556391@news.siol.net>,
  jmodic@src.si (Jurij Modic) wrote:
> On Tue, 29 Dec 1998 14:29:57 -0800, Jonathan Ingram
> <jonathan.ingram@miname.com> wrote:
>
> >boonsong wrote:
> >
> >> Any way to get RowCound by not using Select count(*) from table
> >
> >Yes. Don't select count (*); instead, do one of the following:
> >
> >   select count (1) from <table>;
> >   select count (rowid) from <table>;
>
> Which, in any case, will return exactly the same result as "select
> count(*)"
>
> >Jonathan
>
> Regards,
> Jurij Modic <jmodic@src.si>
> Certified Oracle7 DBA (OCP)
> ================================================
> The above opinions are mine and do not represent
> any official standpoints of my employer
>
Alternatively, you could analyze the table and select the corresponding column
from user_tables.

--
Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own