Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is rebuild index??

Answer Posted / mohapatra.gouranga@gmail.com

> Index rebuild nothing of Drop and re-create of Index.
> Is usefull to move index from one tablespace to other.
> Do not do if not necessary.
> In case of migration, do only validate structure for the
indexex.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2717


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2195


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2617


what is logical system in sap basis

1636


Query processing is slow(eg select query)how will u solve that

7909


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1983


what are the benefits of flashback feature?

1021


how can you create a user-defined lock?

1015


What are the different sql server versions you have worked on? : sql server DBA

1009


how can you record information about current session?

1045


how can you schedule a job in database?

1112


How can you control the amount of free space in your index pages? : sql server DBA

1304


how can you find out if a table can be redefined?

1011


What are the different types of database compression introduced in sql server 2008? : sql server DBA

1102


what are the types of connection load-balancing?

996