asked on

Is indexing possible in snapshot Database (SQL Server 2005)

I am planning on using a Snapshot Database for a read-only database that is being used for reporting, using the SNAPSHOT OF command.

Is it possible to create index on this snapshot database, to make the reports more efficient?

Thanks

ASKER CERTIFIED SOLUTION

Aneesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anushahanna

ASKER

so the indexes carry over to the snapshot database?

But can we create any new index on the snapshot database?

SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Anthony Perkins

>>But can we create any new index on the snapshot database?<<
Let's try it this way: No.

anushahanna

ASKER

acperkins,
very sorry.. that was a big oversight on my part.. Thanks for your patience and clarrifying that in simplest terms.

I had read that article when you mentioned it first, and observed the heart of what this feature is all about.

You have convinced me of snapshot databases, and i have been playing with it some, and i was thinking hard before moving on, this topic being new to me, if i am missing any other details, and that is where this oversight came into the picture..

aneeshattingal,
Thanks for mentioning the moving of the indexes into the destination Snapshot database. That makes perfect sense.

anushahanna

ASKER

in my test, the Snapshot database queries, some complex, were much faster than in the source database. What feature of snapshot database would you attribute this to?

anushahanna

ASKER

The question was due to an oversight, but the answers gave me a good perspective, understanding, and also reading the article again, re-affirmed what i have been learning for the past 2 weeks.

Aneesh

may be it is using a differebt execution plan, check and compare the execution plans