Finding the fillfactor - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Finding the fillfactor

Author

Topic

schinni
Yak Posting Veteran

66 Posts

Posted - 2003-06-04 : 14:00:16

we have fill factor different for all indexes is there
a system table or any sql to get the fillfactors for each index.

Thanks,

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-06-04 : 14:22:31

Yes, it is in the OrigFillFactor column in the sysindexes table.

Tara

schinni
Yak Posting Veteran

66 Posts

Posted - 2003-06-04 : 15:34:58

It gives the original fillfactor when the table is created but we
changed on some indexes to 90 and some to 80.I can see 0(Zero) in
the origfillfactor column in sysindexes table

Thanks,

schinni
Yak Posting Veteran

66 Posts

Posted - 2003-06-04 : 15:55:15

Tara,

I am sorry i overlooked at that table and column,you are correct

thanks very much

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources