NPTOTAL

Posted in 2008

mohitanchlia@gmail.com — Fri, 18 Jan 2008 14:49:35 -0800 (PST) — source: Usenet: comp.databases.informix

Version IDS 10: Why is it that in sysptnhdr NPTOTAL is much higher for indexes as compared to NPUSED. What does it really mean ? - Is it because of Fill Factor - or is it because of size of table that determines how to pre allocate. - Also, what happens when NPUSED = NPTOTAL ?