Re: Why isn't Oracle Using My Index

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 21 Dec 2006 12:08:42 -0800
Message-ID: <bf46380612211208y6faf4e30nc1b97ae6afb58d3c@mail.gmail.com>

On 12/21/06, Joel.Patterson_at_crowley.com <Joel.Patterson_at_crowley.com> wrote:
>
> Runstats is great, and is especially geared towards latches, (is query
> scalable). However, you need a database without anyone else on it to get
> accurate results.
>

I'll play Devil's advocate and say "Why?"

It seems to me that running a problem query on a production system with runstats would be a very good idea. eg. it will allow you to see how the SQL statements will compare when competing for resources with a real workload.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Thu Dec 21 2006 - 14:08:42 CST