Re: How to set FILLFACTOR
From: Nags (nags_at_RemoveThishotmail.com)
Date: 12/30/04
- Previous message: Jéjé: "Re: How to set FILLFACTOR"
- In reply to: Jéjé: "Re: How to set FILLFACTOR"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Dec 2004 12:52:03 -0500
All the datawarehouse tables do not have any constraints. Only Indexes.
This is what we do :
Drop all indexes (except clustered indexes)
Load data
Recreate all indexes.
The total process itself take about 20 hours. Looking for options to
improve performance.
-Nags
"Jéjé" <willgart@BBBhotmailAAA.com> wrote in message
news:OnjM5Up7EHA.2540@TK2MSFTNGP09.phx.gbl...
> best way:
> delete all indexes, fill the table, recreate the indexes.
>
> second option:
> disable constraint validation, load the table, defrag your indexes after
> loading the table
> disabling the constraint like foreign key check etc... improove the
> performance, but the index creation time degrade the performance. (but
make
> sure you load valid data in your table)
>
> "Nags" <nags@RemoveThishotmail.com> wrote in message
> news:ufTYvko7EHA.2124@TK2MSFTNGP14.phx.gbl...
> >I need some help on how to improve performance when loading tables.
> >
> > We have a datawarehouse and sometimes it is needed that the entire
> > datawarehouse is refreshed. (like when test is refreshed from
production)
> >
> > The datawarehouse tables are refreshed by a set of sql statements. Take
> > for
> > example there is a COMPANY table, the data is denormalized with the
> > address,
> > and user information stored along with company information. In order to
do
> > that, initiallly company information is populated and then address &
user
> > information is updated to it. In this entire process, all indexes
except
> > the clustered index is dropped at the beginning of the process and
> > recreated
> > at the end of the data load. In order to improve the process, if I set
> > the
> > FILLFACTOR to 10 or 20 on the clustered index, will it really help ? I
> > understand from the documentation that FILLFACTOR is used only when the
> > index is created, so if I loading data to an existing table, FILLFACTOR
> > will
> > be of no use, correct ?
> >
> > Is there anything else that I can do to imporve the performance of such
> > table loads. All loads are with first inserting core data and then
> > updating
> > the related data.
> >
> > The database is already set to SIMPLE mode.
> >
> > -Nags
> >
> >
>
>
- Previous message: Jéjé: "Re: How to set FILLFACTOR"
- In reply to: Jéjé: "Re: How to set FILLFACTOR"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
