Btree Index Level

Posted in 2004

miyaki — Mon, 29 Mar 2004 02:05:59 — source: IIUG Forums & Mailing Lists

Hi all, I have a database running with FILLFACTOR at 90%. I'm not sure is this the correct value I should maintain. From the documentation, the FILLFACTOR is the parameter to controling how indexes are filled. With the current setting, the database only has 10% room of index growth. Since the database is supporting a heavy OLTP type of transaction, I'm afraid that the 10% room for growth might not sufficient and might create a multi level of index nodes which may affect the performance. Is there a way to find how many level of index nodes in the database? Thanks & regards, Miyaki __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html

↪ replying to miyaki

Martin Fuerderer — Mon, 29 Mar 2004 06:36:28 — source: IIUG Forums & Mailing Lists

Hi, as user informix do: oncheck -pT <database name>:<tablename> This will give you a report on the table and the indexes belonging to the table. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "miyaki " <lcib@yahoo.com> Sent by: forum.subscriber@iiug.org 29.03.2004 04:06 To ids@iiug.org cc Subject Btree Index Level [2756] Hi all, I have a database running with FILLFACTOR at 90%. I'm not sure is this the correct value I should maintain. From the documentation, the FILLFACTOR is the parameter to controling how indexes are filled. With the current setting, the database only has 10% room of index growth. Since the database is supporting a heavy OLTP type of transaction, I'm afraid that the 10% room for growth might not sufficient and might create a multi level of index nodes which may affect the performance. Is there a way to find how many level of index nodes in the database? Thanks & regards, Miyaki __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html

↪ replying to miyaki

paul@oninit.com — Mon, 29 Mar 2004 07:40:14 — source: IIUG Forums & Mailing Lists

Check out sysindexes, levels and leaves miyaki wrote: > > Hi all, > > I have a database running with FILLFACTOR at 90%. I'm > not sure is this the correct value I should maintain. > >From the documentation, the FILLFACTOR is the > parameter to controling how indexes are filled. With > the current setting, the database only has 10% room of > index growth. Since the database is supporting a heavy > OLTP type of transaction, I'm afraid that the 10% room > for growth might not sufficient and might create a > multi level of index nodes which may affect the > performance. Is there a way to find how many level of > index nodes in the database? > > Thanks & regards, > Miyaki > > __________________________________ > Do you Yahoo!? > Yahoo! Finance Tax Center - File online. File on time. > http://taxes.yahoo.com/filing.html -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to miyaki

miyaki — Mon, 29 Mar 2004 10:56:26 — source: IIUG Forums & Mailing Lists

What is the acceptable levels and leaves for each index? --- paul@oninit.com wrote: > Check out sysindexes, levels and leaves > > miyaki wrote: > > > > Hi all, > > > > I have a database running with FILLFACTOR at 90%. > I'm > > not sure is this the correct value I should > maintain. > > >From the documentation, the FILLFACTOR is the > > parameter to controling how indexes are filled. > With > > the current setting, the database only has 10% > room of > > index growth. Since the database is supporting a > heavy > > OLTP type of transaction, I'm afraid that the 10% > room > > for growth might not sufficient and might create a > > multi level of index nodes which may affect the > > performance. Is there a way to find how many level > of > > index nodes in the database? > > > > Thanks & regards, > > Miyaki > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Finance Tax Center - File online. File on > time. > > http://taxes.yahoo.com/filing.html > > -- > Paul Watson # > Oninit Ltd # Growing old is mandatory > Tel: +44 1436 672201 # Growing up is optional > Fax: +44 1436 678693 # > Mob: +44 7818 003457 # > www.oninit.com # __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html