Re: UPDATE STATISTICS Question
Good Question and one I would love to see someone from Informix answer. It really wasn't that long ago that a 3-500 MB Database was considered large. Snicker if you will but it's true. Now we talk in Terrabytes of data. Is a small table anything less than a GIG...or one that has an INDEX size of less than a GIG. Inquiring minds want to know... Rob Vorbroker Lucky Leavell [RIS] <ris@iglou.com> wrote in message news:Pine.GSO.4.31.0101041548490.11176-100000@shell1... > Informix 7.31 > > In the Performance Guide (or was it the SQL Syntax Guide), it states > that one should use HIGH for the entire table on small tables. Just > what qualifies as a "small" table: 1000 rows? 100,000 rows? ?? > > > Thank you, > Lucky > > Lucky Leavell Phone: (800) 481-2393 or (812) 366-4066 > UniXpress - Your Source for SCO FAX: (888) 231-9640 or (812) 366-3618 > 1560 Zoar Church Road NE Email: lucky@UniXpress.com > Corydon, IN 47112-7374 WWW Home Page: http://www.UniXpress.com >
I would think that what constitiutes a small table on a Sun E10000 may be a big table on an Ultra5. I would define a "small" table in this instance as any table that you could run "update statistics high" in under 5 minutes or whatever time works for you (unless you have 500 "small" tables). ROBERT B VORBROKER wrote: > > Good Question and one I would love to see someone from Informix answer. > It really wasn't that long ago that a 3-500 MB Database was considered > large. > Snicker if you will but it's true. Now we talk in Terrabytes of data. Is a > small table > anything less than a GIG...or one that has an INDEX size of less than a GIG. > > Inquiring minds want to know... > > Rob Vorbroker > > Lucky Leavell [RIS] <ris@iglou.com> wrote in message > news:Pine.GSO.4.31.0101041548490.11176-100000@shell1... > > Informix 7.31 > > > > In the Performance Guide (or was it the SQL Syntax Guide), it states > > that one should use HIGH for the entire table on small tables. Just > > what qualifies as a "small" table: 1000 rows? 100,000 rows? ?? > > > > > > Thank you, > > Lucky > > > > Lucky Leavell Phone: (800) 481-2393 or (812) 366-4066 > > UniXpress - Your Source for SCO FAX: (888) 231-9640 or (812) 366-3618 > > 1560 Zoar Church Road NE Email: lucky@UniXpress.com > > Corydon, IN 47112-7374 WWW Home Page: http://www.UniXpress.com > >