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

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 9 Mar 2014 08:14:37 -0500
Message-ID: <CAORjz=OVkXdQ8vVL3oh7obaLD9Rz1F2WmRy2MX_Jn4RrFWTqgw_at_mail.gmail.com>

On Wed, Mar 5, 2014 at 11:56 AM, Fred Habash <fmhabash_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

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