Oracle - how do you know index is invalid?

GeekInterview.com > Interview Questions > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 25 of 81

how do you know index is invalid?

Total Answers and Comments: 7

Last Update: February 01, 2008 Asked by: winston

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

May 21, 2006 14:47:09

Ajeet Singh

RE: how do you know index is invalid?

We can

Is this answer useful? Yes | No

May 21, 2006 14:49:21

Ajeet Singh

RE: how do you know index is invalid?

We can know the status of Indexes by Data dictionary view dba_index. That index is valid or invalid.

Is this answer useful? Yes | No

May 27, 2006 03:29:18

srinivas

RE: how do you know index is invalid?

when indexing column contains null values

Is this answer useful? Yes | No

August 02, 2006 02:58:26

ajay

RE: how do you know index is invalid?

The status of index or any object can be know by querying the view user_objects.And there is not database dictionary by the name dba_index

Is this answer useful? Yes | No

March 06, 2007 05:46:36

Raam

RE: how do you know index is invalid?

We can know the status of the Indexes using the User_indexes dictionary table.Even u can know the status from USER_OBJECTS table also..

Raam

Is this answer useful? Yes | No

July 16, 2007 13:02:05

deepsk singh

RE: how do you know index is invalid?

If you want to know which one is invalid/valid; you find out from the data dictonary table user_objects and execute query

select * from user_objects

where object_type 'INDEX'

and status 'INVALID' ---and status 'VALID'

Is this answer useful? Yes | No

February 01, 2008 00:43:44

Sant_parkash

Member Since: October 2007 Contribution: 26

RE: how do you know index is invalid?

select * from user_indexes where status 'Invalid'
you can specify index_name in the same query to look for a particular INDEX.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank