Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: COUNT(*) takes forever

Re: COUNT(*) takes forever

From: George Meltser <meltser_at_aigfpc.com>
Date: Fri, 05 Feb 1999 20:26:02 GMT
Message-ID: <utIu2.16$rs2.57337@client.news.psi.net>

If you analyze the table, select count(*) works much faster Received on Fri Feb 05 1999 - 14:26:02 CST

This message: [ Message body ]
Next message: Jonathan Lewis: "Re: How to drop Datafile from Tablespace?"
Previous message: Mark Watts: "Tying Oracle to NT process id's ?"
In reply to: Dharambir Marwaha: "Re: COUNT(*) takes forever"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US