topic Re: configuration parameter SQL fillfactor_ in Geodatabase Questions

configuration parameter SQL fillfactor_

DasheEbra — Tue, 23 Nov 2021 13:06:29 GMT

I want to know more about SQL FillFactor,

what I know is that SQL server DB consist of Data file (.mdf or .ndf), and data files consist of Extents also each extent have 8 pages, therefore each page takes a number or percent from 0 to 100 to write in it (which is the FillFactor) so i want to know what is the benefit for this if I change it to 50 or 80??

Re: configuration parameter SQL fillfactor_

VinceAngelo — Mon, 06 Dec 2021 18:52:08 GMT

The RDBMS documentation is likely a better resource for this information than a GIS forum.

I haven't changed FillFactor in ages, but if I had a static table, I'd run it up to 100%, and if I had a dynamic table I'd set it lower (depending on the way keys were filling, and how often I was rebuilding indexes).

- V