How do you know index is invalid?

  • Interview Candidate
  • 13
  • 20218

Showing Answers 1 - 13 of 13 Answers

Ajeet Singh

  • May 21st, 2006
 

We can

  Was this answer useful?  Yes

Ajeet Singh

  • May 21st, 2006
 

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

  Was this answer useful?  Yes

srinivas

  • May 27th, 2006
 

when indexing column contains null values

  Was this answer useful?  Yes

ajay

  • Aug 2nd, 2006
 

   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

  Was this answer useful?  Yes

Raam

  • Mar 6th, 2007
 

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

  Was this answer useful?  Yes

deepsk singh

  • Jul 16th, 2007
 

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'

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions