By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,030 Members | 1,227 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,030 IT Pros & Developers. It's quick & easy.

changing indexes

P: n/a
Hi, My application goes through a lengthy data processing phase before
it's ready to run. During the DP phase I'm mostly inserting records,
afterwards many of my tables will be read only. Is there anything
wrong with dropping indexes used for the DP and setting up clustered
indexes afterwards? Can I just declare my clustered indexes and go,
or do I have run some kind of statistics ...?

Oct 6 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi

There is nothing wrong in doing this, but it sounds like you are possibly
trying to reinvent what analysis services does!!!

If you are inserting a significant number of records your indexes may be
fragmented and therefore defragmenting them or re-creating them are
necessary activities. You may wish to change the fillfactor if your tables
are read only and have a lower fill factor whilst loading and 100% fill
factor when readonly.

You may also want to consider moving this data load offline into a separate
database, then you swap in the new data when it has been built and reduce
downtime. The whole database could be read only!

John

"Johnny Ruin" <sc**********@gmail.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
Hi, My application goes through a lengthy data processing phase before
it's ready to run. During the DP phase I'm mostly inserting records,
afterwards many of my tables will be read only. Is there anything
wrong with dropping indexes used for the DP and setting up clustered
indexes afterwards? Can I just declare my clustered indexes and go,
or do I have run some kind of statistics ...?

Oct 8 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.