Webastor - Programming Tips and Tricks

Programming language => Sql => Topic started by: Mckenzie on April 23, 2016, 01:31:01 PM

Title: While creating an index if I mention PAD INDEX” what does it mean?
Post by: Mckenzie on April 23, 2016, 01:31:01 PM
Hi, I would like to ask you for your cooperation in order to know while creating an index if i mention “pad index” what does it mean? Thank you for your help.
Title: Re: PAD INDEX
Post by: Lucian on June 05, 2017, 05:17:50 PM
PAD_INDEX ON means "Apply FILLFACTOR to all layers"
This is the root node and intermediate level in the picture below