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