Oninit cdi / Archive
Talk to an expert →

Re: NPTOTAL

Posted in 2008

Topics: High Availability & Replication

Mark Jamison — — source: Usenet: comp.databases.informix

Hi, How much higher? ----- Original Message ---- From: "mohitanchlia@gmail.com" <mohitanchlia@gmail.com> To: informix-list@iiug.org Sent: Friday, January 18, 2008 4:46:18 PM Subject: NPTOTAL 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 ? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Mark Jamison
mohitanchlia@gmail.com — — source: Usenet: comp.databases.informix

On Jan 18, 5:30 pm, Mark Jamison <maj...@yahoo.com> wrote: > Hi, > > How much higher? > > ----- Original Message ---- > From: "mohitanch...@gmail.com" <mohitanch...@gmail.com> > To: informix-l...@iiug.org > Sent: Friday, January 18, 2008 4:46:18 PM > Subject: NPTOTAL > > 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 ? > _______________________________________________ > Informix-list mailing list > Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list How are extents (NPTOTAL) size calculated for indexes ? Is fill factor part of criteria for determining Index extent size ?

↪ replying to mohitanchlia@gmail.com
Paul Watson — — source: Usenet: comp.databases.informix

mohitanchlia@gmail.com wrote: > On Jan 18, 5:30 pm, Mark Jamison <maj...@yahoo.com> wrote: >> Hi, >> >> How much higher? >> >> ----- Original Message ---- >> From: "mohitanch...@gmail.com" <mohitanch...@gmail.com> >> To: informix-l...@iiug.org >> Sent: Friday, January 18, 2008 4:46:18 PM >> Subject: NPTOTAL >> >> 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 ? >> _______________________________________________ >> Informix-list mailing list >> Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list > > How are extents (NPTOTAL) size calculated for indexes ? Is fill factor > part of criteria for determining Index extent size ? Detached Index extent size = ( (index_key_size + 9) / table_row_size) * table_extent_size AFAIK user defined index extent sizing is something that is coming Cheers Paul

Glossary