INDEX WITH FILLFACTOR

INDEX WITH FILLFACTOR is a SQL statement in the Indexes category. FILLFACTOR reserves free space on index pages for future insertions. Reduces page splits. SQL Server. The syntax is CREATE INDEX idx_name ON table (col) WITH (FILLFACTOR = 80);. It returns index with fillfactor. A typical example: CREATE INDEX idx_name ON employees (last_name) WITH (FILLFACTOR = 80); -- 80% fill, 20% free space per page -- Good for tables with frequent inserts (reduces page splits) CREATE INDEX idx_id ON lookup_table (code) WITH (FILLFACTOR = 100); -- 100% fill — no free space -- Good for read-only/reference tables -- ALTER INDEX to rebuild with new fillfactor: ALTER INDEX idx_name ON employees REBUILD WITH (FILLFACTOR = 90); A close relative is CREATE INDEX, which creates an index on one or more columns to speed up query performance. A close relative is DROP INDEX, which removes an existing index from a table.