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

From: Jared Still <jkstill@xxxxxxxxx>
To: fmhabash@xxxxxxxxx
Date: Sun, 9 Mar 2014 08:14:37 -0500

On Wed, Mar 5, 2014 at 11:56 AM, Fred Habash <fmhabash@xxxxxxxxx> 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 http://www.pythian.com/blog/author/still/
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

Follow-Ups:
- RE: Optimizing a Simple 'select count(*)'
  - From: Jonathan Lewis

References:
- Optimizing a Simple 'select count(*)'
  - From: Fred Habash

Other related posts:

» Optimizing a Simple 'select count(*)'- Fred Habash
» RE: Optimizing a Simple 'select count(*)'- Clark, Tommy R
» Re: Optimizing a Simple 'select count(*)'- Mark Bobak
» RE: Optimizing a Simple 'select count(*)'- Mark W. Farnham
» Re: Optimizing a Simple 'select count(*)'- David Fitzjarrell
» Re: Optimizing a Simple 'select count(*)'- David Fitzjarrell
» RE: Optimizing a Simple 'select count(*)'- Tefft, Michael J
» Re: Optimizing a Simple 'select count(*)'- Mark Bobak
» RE: Optimizing a Simple 'select count(*)'- Mark W. Farnham
» Re: Optimizing a Simple 'select count(*)' - Jared Still
» RE: Optimizing a Simple 'select count(*)'- Jonathan Lewis
» RE: Optimizing a Simple 'select count(*)'- McPeak, Matt
» RE: Optimizing a Simple 'select count(*)'- Mark W. Farnham
» RE: Optimizing a Simple 'select count(*)'- Jonathan Lewis
» Re: Optimizing a Simple 'select count(*)'- Juan Carlos Reyes Pacheco