Re: fillfactor

tony edwards wrote: > > Hi, > > Does anyone use the "fillfactor" syntax when creating an index ? If so > have you noticed reduction in the physical size used by the index ? > and > does this result in better performance ? You won't see a reduction in size unless you are INCREASING your fill factor. Each node is still a page, but the fill factor indicates how much of each node to fill, thus how much space to leave for expansion without the need to split nodes. You would only expect to see an improvement in performance if your index was growing initially. After the nodes are 100% full, normal rules apply for node splitting. Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+