Database Administration - How are the index updates

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 21 of 231

How are the index updates

Total Answers and Comments: 3

Last Update: April 08, 2009

Sponsored Links

Best Rated Answer

—

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

June 18, 2005 01:17:12

soccer_champ

RE: How are the index updates

Indexes can be updated by either Dropping and recreating them or Rebuilding them online.
In case of any doubt mail me :
bobby_1020@hotmal.com

Is this answer useful? Yes | No

April 07, 2009 12:41:12

sivaraju.sateesh

Member Since: January 2009 Contribution: 10

RE: How are the index updates

index gets updated as deleting the previous values and inserting the new value.

Is this answer useful? Yes | No

April 08, 2009 01:22:10

Prashidha

Member Since: April 2009 Contribution: 1

RE: How are the index updates

We can update the index by rebuilding it.

Alter index indexname rebuilt

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank