Also data_types of the columns involved. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marcin Przepiorowski Sent: Monday, October 03, 2011 8:38 PM To: Mark.Bobak@xxxxxxxxxxxx Cc: oralrnr@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: Re: Performance bad with and without index On Tue, Oct 4, 2011 at 12:45 AM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx> 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l