Re: fillfactor

Don't forget that you only get the desired fillfactor if the columns being indexed are or are nearly unique. If it's highly duplicative, I've seen as bad as 40% full on average with fillfactor 100 specified. Oncheck -pT tells the tale. Nice "feecher" huh? Greg Mark D. Stock wrote: > > tony edwards wrote: > > > > Hi, > > > > Does anyone use the "fillfactor" syntax when creating an index ? If so > > have you noticed reduction in the physical size used by the index ? > > and > > does this result in better performance ? snip......