|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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_tp 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? Show quoteHide quote "pradeep_TP" <pradee***@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 Show quoteHide quote "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" <pradee***@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. Show quoteHide quote "pradeep_TP" <pradee***@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" <pradee***@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. -- Show quoteHide quoteGail Erickson [MS] SQL Server Documentation Team This posting is provided "AS IS" with no warranties, and confers no rights "pradeep_TP" <pradee***@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" <pradee***@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). -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "pradeep_TP" <pradee***@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  
Other interesting topics
SQL 2005 unrestricted log file
SQL Server Enterprise Manager Error Benefits of 64bit SQL? SQL Server 2005 and VS2005 Unable to grant rights to user Backup how to simplify what i'm doing (AS the solution?) Sysindexes table error - cannot repair Changing the database from MSAccess to MSSQLServer. Writing time problem |
|||||||||||||||||||||||
