Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Index

Status
Not open for further replies.

myrcmstr

IS-IT--Management
Feb 24, 2007
9
US
How to turn off index and turn on index? We have big fact table with 64 milion rows per month. To load this huge table I want to turn off index and after laoding i want to turn on index. How to do this through informatica/database?
 
Simply include the Index Drop and Index Create DDL in Pre and Post SQL for the Mapping connections
 
With Index drop and create it needs to create indexes from scrach. Can it be possible to update existing indexes?
 
After large operations on a table it is always smart to execute statistics. This will ensure that the optimizer will have up-to-date info.

Ties Blom

 
Will the indexes be updated with 'Update Statistics' without recreation?
 
This behavior may vary between RDBMS. You should look into the specifics of the target database you are working with.
My 2 cents: without specifying, both column and index statistics will be updated.

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top