Re: Performance bad with and without index
From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Tue, 4 Oct 2011 01:38:19 +0100
Message-ID: <CAGdek=w-kANG=CDcrjioyOzwXq8VwoET2W5TGqje+P57ExPMkQ_at_mail.gmail.com>
On Tue, Oct 4, 2011 at 12:45 AM, Bobak, Mark <Mark.Bobak_at_proquest.com> wrote:
> You might want to provide us the execution plan and the DDL of the index, if you want us to take a closer look.
>
Date: Tue, 4 Oct 2011 01:38:19 +0100
Message-ID: <CAGdek=w-kANG=CDcrjioyOzwXq8VwoET2W5TGqje+P57ExPMkQ_at_mail.gmail.com>
On Tue, Oct 4, 2011 at 12:45 AM, Bobak, Mark <Mark.Bobak_at_proquest.com> wrote:
> You might want to provide us the execution plan and the DDL of the index, if you want us to take a closer look.
>
DB version , server spec and memory configuration will be helpful as well to do any recommendations.
regards,
-- Marcin Przepiorowski http://oracleprof.blogspot.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 03 2011 - 19:38:19 CDT