×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Index

Index

(OP)
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?

RE: Index

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

RE: Index

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

RE: Index

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
 

RE: Index

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

RE: Index

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
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close