RE: Performance bad with and without index
From: Kenneth Naim <kennethnaim_at_gmail.com>
Date: Mon, 3 Oct 2011 22:13:10 -0400
Message-ID: <009701cc823b$2b598470$820c8d50$_at_gmail.com>
Also data_types of the columns involved.
Date: Mon, 3 Oct 2011 22:13:10 -0400
Message-ID: <009701cc823b$2b598470$820c8d50$_at_gmail.com>
Also data_types of the columns involved.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Marcin Przepiorowski
Sent: Monday, October 03, 2011 8:38 PM
To: Mark.Bobak_at_proquest.com
Cc: oralrnr_at_gmail.com; oracle-l_at_freelists.org
Subject: Re: Performance bad with and without index
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-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 03 2011 - 21:13:10 CDT