Tuesday, March 27, 2012

Database snapshot

I drop and recreate a database snapshot for reporting purposes at the end of a DW loading process.

I need to create some indexes to improve query performance.

Where I should create the index, on the originale db or on the snapshot db ?

Cosimo

If I remember from an article, you can not do this on a snapshot database. So I guess you should do this on the source DB. Please check it though.|||

SOLVED

I create the index on the source db.

No comments:

Post a Comment