On Tue, Jul 14, 2009 at 3:04 PM, Nancy Iles <nancy_iles@xxxxxxxxxxx> wrote: > > Yes, the there is an index on CONFIRMATION_NO and I have found that > _OPTIM_PEEK_USER_BINDS=FALSE on all 6 RAC nodes. So, now on to research the > other suggestions! Thanks to everyone for your input. > My question was actually slightly different. The index exists, but is it being used? Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist