Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Unique index not being used, up to date stats

Re: Unique index not being used, up to date stats

From: Ben <balvey_at_comcast.net>
Date: 26 Jan 2007 10:39:34 -0800
Message-ID: <1169836774.529837.174850@v45g2000cwv.googlegroups.com>

On Jan 26, 1:24 pm, "Valentin Minzatu" <valentinminz..._at_yahoo.com> wrote:
> What are the response times with and without the INDEX hint?

with the hint < sec, without > 5 mins.

This has just started happening too. This table has enough activity that even with using GATHER STALE it is analyzed almost every weekend, and I haven't had this problem before. Received on Fri Jan 26 2007 - 12:39:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US