Hi,
As far as I know the fillfactor for an index depends on how often you do
inserts or updates and what type of field it is.
if for instance the field is a sequence number that gets incremented
ascending or descending then you ok to use a fill factor of 100. but if the
field is not a sequence and the table gets inserted a lot and the field gets
updated a lot then less than 100% fill factor should be used otherwise page
splitting will occur a lot.
Hope this helps.
M&M
-----Original Message-----
From: Daylinda Sanchez [mailto:Daylinda.[Email Address Removed] 29 April 2004 23:04
To: LazyDBA.com Discussion
Subject: Index fill factor
Hi there,
Can anyone please advise/share how you handle your fill factor settings?
Currently, I am looking at a database (20 GB) size and there are at least
10 transactional tables in it. The current fill factor is set to default
which is 0. In BOL it says, every time the indexes are being rebuilt, it
will set the index page to 100% full thus creating page splits everytime a
new data is inserted.
I am running DBreindex once a week too. Is this efficient enough?
Daylinda Sanchez
We should be taught not to wait for inspiration to start a thing. Action
always generates inspiration. Inspiration seldom generates action.
-- Frank Tibolt
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004
----------
The information contained in this e-mail and any attachments is confidential
and is intended for the attention and use of the named addressee(s) only.
Any views expressed in this message are those of the individual sender and
may not necessarily reflect the views of Chelmer Limited.
This communication contains information which is confidential and may be
legally privileged and is for the exclusive use of the addressee(s). If you
are not a named addressee please contact the sender immediately, and delete
the communication from your system. You are hereby notified that any
disclosure, distribution or copying of this communication, in whole or in
part, is strictly prohibited. Any views or opinions presented are solely
those of the author and do not necessarily represent those of the Company,
its directors or officers unless otherwise specifically stated. The Company
is not responsible for any reliance placed on the information contained
herein and excludes all liability.
(c)Copyright 2003 Siemens Energy Services Limited. All Rights Reserved.
MS Sql Server LazyDBA home page