Doh!!
The problem is whether there is statistics on the table or not.
It's that RBO/CBO issue.
This feature (skip unusable indexes) needs stats.
To confirm it, I ran the following test on AIX 4.3.3 (should get same results on AIX
5L)
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Pr
I think the problem is skip_unusable... isn't an init.ora parameter. At
least it wasn't in earlier versions. You can set it at session level
'alter session set skip_unusable_indexes...'. I ended up adding it to a
logon trigger to make it affect all sessions.
HTH.
-Original Message-
S
If the index is a unique index, then ORA-1502 is not suppressed.
If not, it surely looks like a bug.
File an iTAR, and let us know how OWS addresses it.
- Kirti
--- Sai Selvaganesan <[EMAIL PROTECTED]> wrote:
> hi
> i am trying to figure out how unusable indexes could
> help me in certain cas
Title: RE: Unusable indexes : why ?
Stephane, I had this happen to me previously.
Did you by chance use an /*+ APPEND */ hint? That was another possible culprit that was mentioned to me. Did you move the table ? ALTER TABLE ... MOVE ... ??
Lisa Koivu
Data Bored Administrator
Ft
Did anyone do alter table <> MOVE ?
--- paquette stephane <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> Oracle 816, I just had 13 unusable indexes (btree
> and
> bitmap).
> I have no partition and no sql*loader load so how
> come
> those 13 indexes are unusable ?
>
>
>
> =
> Stéphane Paquette
> DBA
Did you move the tables around?
-Original Message-
Sent: Wednesday, July 11, 2001 12:27 PM
To: Multiple recipients of list ORACLE-L
Hi,
Oracle 816, I just had 13 unusable indexes (btree and
bitmap).
I have no partition and no sql*loader load so how come
those 13 indexes are unusable ?
Move any tables via ALTER TABLE ... MOVE recently?
> -Original Message-
> From: stephane.paquette [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 11, 2001 11:27 AM
> To: ORACLE-L; stephane.paquette
> Subject: Unusable indexes : why ?
>
>
> Hi,
>
> Oracle 816, I just had 13 unusable