Index fragmentation

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  April 8, 2013 at 1:18 am

  #270677

  HI All,

  The table is not using the specified fillfactor after rebuild the index.

  Please find the attached doc, where i have mentioned my question.

  Thanks

  

• Vegard Hagen

  Hall of Fame

  Points: 3078

  More actions

  April 8, 2013 at 1:43 am

  #1604296

  I'm thinking your fill factor isn't being used because your entire table fits on a single page.

  ---

  Kind regards,

  Vegard Hagen
  Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
  @vegard_hagen on Twitter
  Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)

  It is better to light a candle than to curse the darkness. (Chinese proverb)