Re: Optimizing a Simple 'select count(*)'

From: Jared Still <>
Date: Sun, 9 Mar 2014 08:14:37 -0500
Message-ID: <>

On Wed, Mar 5, 2014 at 11:56 AM, Fred Habash <> wrote:

> So, why should we live with such costly resource consumptions for such a
> simple query?

We don't know enough about the tables and/or indexes.

If you include complete code for a reproducible test case, you will likely get more response.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Sr Oracle DBA at Pythian
Pythian Blog Oracle Blog: Home Page:

Received on Sun Mar 09 2014 - 14:14:37 CET

Original text of this message