|
|
Posted by John Bell on 10/08/05 22:10
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" <schafer.dave@gmail.com> wrote in message
news:1128630847.225685.79080@g43g2000cwa.googlegroups.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 ...?
>
Navigation:
[Reply to this message]
|