Index

[myrcmstr]

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?

 

[rasETL]

Simply include the Index Drop and Index Create DDL in Pre and Post SQL for the Mapping connections

 

[myrcmstr]

With Index drop and create it needs to create indexes from scrach. Can it be possible to update existing indexes?

 

[blom0344]

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

 

[myrcmstr]

Will the indexes be updated with 'Update Statistics' without recreation?

 

[blom0344]

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