FillFactor and Intermeditory Pages

hi all,
I am trying to understand more about fillfactor. After reading few articiles
on internet, I came to know that, the fillfactor is effective only on leaf
node/page. Does it mean that fillfactor will not have any effect on the
intermediatory pages.
thanks
pradeep_tpHi
You need to understand that lower value of FILL FACTOR leaves more empty
space on data page
Actually FILLFACTOR option means how full is your data page
In my opinion BOL has pretty good explanation about FILL FACTOR.
What is your concern?
"pradeep_TP" <pradeepTP@.discussions.microsoft.com> wrote in message
news:DF4F5805-5BFD-4E46-A26C-EA3758FB2FA7@.microsoft.com...
> hi all,
> I am trying to understand more about fillfactor. After reading few
> articiles
> on internet, I came to know that, the fillfactor is effective only on leaf
> node/page. Does it mean that fillfactor will not have any effect on the
> intermediatory pages.
> thanks
> pradeep_tp|||Hi Uri,
My concern is knowledge. I want to fully undestand it fill factor. According
to what you say, fillfactor is effective only for data pages and not for
index pages. Am i correct. Also what is BOL?
pradeep
"Uri Dimant" wrote:
> Hi
> You need to understand that lower value of FILL FACTOR leaves more empty
> space on data page
> Actually FILLFACTOR option means how full is your data page
> In my opinion BOL has pretty good explanation about FILL FACTOR.
> What is your concern?
>
> "pradeep_TP" <pradeepTP@.discussions.microsoft.com> wrote in message
> news:DF4F5805-5BFD-4E46-A26C-EA3758FB2FA7@.microsoft.com...
> > hi all,
> >
> > I am trying to understand more about fillfactor. After reading few
> > articiles
> > on internet, I came to know that, the fillfactor is effective only on leaf
> > node/page. Does it mean that fillfactor will not have any effect on the
> > intermediatory pages.
> >
> > thanks
> > pradeep_tp
>
>|||Hi
The fill factor is implemented only when the index is created
BOL says
FILL Factor
An attribute of an index that defines the amount of free space on each page
of the index. FILLFACTOR accommodates future expansion of table data and
reduces the potential for page splits. FILLFACTOR is a value from 1 through
100 that specifies the percentage of the index page to be left empty.
"pradeep_TP" <pradeepTP@.discussions.microsoft.com> wrote in message
news:745FF257-569B-4BCA-8BE1-A919129EA44D@.microsoft.com...
> Hi Uri,
> My concern is knowledge. I want to fully undestand it fill factor.
> According
> to what you say, fillfactor is effective only for data pages and not for
> index pages. Am i correct. Also what is BOL?
> pradeep
> "Uri Dimant" wrote:
>> Hi
>> You need to understand that lower value of FILL FACTOR leaves more
>> empty
>> space on data page
>> Actually FILLFACTOR option means how full is your data page
>> In my opinion BOL has pretty good explanation about FILL FACTOR.
>> What is your concern?
>>
>> "pradeep_TP" <pradeepTP@.discussions.microsoft.com> wrote in message
>> news:DF4F5805-5BFD-4E46-A26C-EA3758FB2FA7@.microsoft.com...
>> > hi all,
>> >
>> > I am trying to understand more about fillfactor. After reading few
>> > articiles
>> > on internet, I came to know that, the fillfactor is effective only on
>> > leaf
>> > node/page. Does it mean that fillfactor will not have any effect on the
>> > intermediatory pages.
>> >
>> > thanks
>> > pradeep_tp
>>|||Yes, fillfactor applies only to leaf level. You do have the PAD_INDEX option which specifies that
the fillfactor value you specify also should be applied to the non-leaf level. But by default,
fillfactor is only applied at leaf level. In 2005, you can specify PAD_INDEX when you do index
rebuild, in earlier versions, you only had the PAD_INDEX option when you create the index (as far as
I remember).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"pradeep_TP" <pradeepTP@.discussions.microsoft.com> wrote in message
news:DF4F5805-5BFD-4E46-A26C-EA3758FB2FA7@.microsoft.com...
> hi all,
> I am trying to understand more about fillfactor. After reading few articiles
> on internet, I came to know that, the fillfactor is effective only on leaf
> node/page. Does it mean that fillfactor will not have any effect on the
> intermediatory pages.
> thanks
> pradeep_tp|||>Also what is BOL?
BOL is short for SQL Server Books Online, the documentation that comes with
the product.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"pradeep_TP" <pradeepTP@.discussions.microsoft.com> wrote in message
news:745FF257-569B-4BCA-8BE1-A919129EA44D@.microsoft.com...
> Hi Uri,
> My concern is knowledge. I want to fully undestand it fill factor.
> According
> to what you say, fillfactor is effective only for data pages and not for
> index pages. Am i correct. Also what is BOL?
> pradeep
> "Uri Dimant" wrote:
>> Hi
>> You need to understand that lower value of FILL FACTOR leaves more
>> empty
>> space on data page
>> Actually FILLFACTOR option means how full is your data page
>> In my opinion BOL has pretty good explanation about FILL FACTOR.
>> What is your concern?
>>
>> "pradeep_TP" <pradeepTP@.discussions.microsoft.com> wrote in message
>> news:DF4F5805-5BFD-4E46-A26C-EA3758FB2FA7@.microsoft.com...
>> > hi all,
>> >
>> > I am trying to understand more about fillfactor. After reading few
>> > articiles
>> > on internet, I came to know that, the fillfactor is effective only on
>> > leaf
>> > node/page. Does it mean that fillfactor will not have any effect on the
>> > intermediatory pages.
>> >
>> > thanks
>> > pradeep_tp
>>