Home » RDBMS Server » Server Administration » Why is one index unused?
Why is one index unused? [message #218983] Mon, 12 February 2007 06:34 Go to next message
aherranp@yahoo.es
Messages: 3
Registered: February 2007
Location: madrid
Junior Member
Hi,
How could I find out the reason for one index to be unused?

Best regards and thank you very much.
Re: Why is one index unused? [message #218990 is a reply to message #218983] Mon, 12 February 2007 07:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You mean, 'unused' with a query, where it is expected to be made use of
or
'Unusable' status of an index after a direct load/related?
Re: Why is one index unused? [message #218993 is a reply to message #218990] Mon, 12 February 2007 07:25 Go to previous messageGo to next message
aherranp@yahoo.es
Messages: 3
Registered: February 2007
Location: madrid
Junior Member

Hi,
It had 'Unusable' status, maybe after a direct load/related, but i don't know.
How could I check it?
Re: Why is one index unused? [message #219012 is a reply to message #218993] Mon, 12 February 2007 09:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch09.htm#1007759
Re: Why is one index unused? [message #219013 is a reply to message #219012] Mon, 12 February 2007 09:57 Go to previous message
aherranp@yahoo.es
Messages: 3
Registered: February 2007
Location: madrid
Junior Member
Thank you very much. We just solve the problem increasing temporary TS. Best regards,
Previous Topic: tablespace UNDOTBS1 almost full, Any help
Next Topic: Opatch failed due to inventory problem.
Goto Forum:
  


Current Time: Sat Dec 10 03:13:45 CST 2016

Total time taken to generate the page: 0.12130 seconds