SQL Server Performance

Pad Index

Discussion in 'General DBA Questions' started by kate_for_u, Aug 22, 2003.

  1. kate_for_u New Member

    Hi

    We are designing a database and the Indexes are being
    created . In the Index the Pad_Index is taking the
    default value of the Fill Factor.

    We for some reasons want to keep different values for PAd_Index
    and Fill_Factor .

    Please suggest a way to do this

    Thanx in Advance
  2. satya Moderator

    The PAD_INDEX option is useful only when FILLFACTOR is specified, because PAD_INDEX uses the percentage specified by FILLFACTOR.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. kate_for_u New Member

    Yeah but can we keep say fill factor = 70 %
    and pad_Index = 80% ?
  4. satya Moderator

    I don't think its possible to define different values.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  5. Eddy New Member

    Without the PAD_INDEX clause, SQL Server creates leaf pages that are x percent full, but the pages above the leaf level are filled almost completely. With PAD_INDEX, the intermediate pages are also x percent full. ("creating index" from Books Online.
  6. satya Moderator

    Do you know whether you can maintain different values for PAD_Index and FF, I don't think so.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  7. Twan New Member

    No you can't There is no pad_index=% option for create index...

    Cheers
    Twan
  8. satya Moderator

    Thats for I'm sure but it helps with a cross-check.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page