db2 min, max, count functions are very slow
This is a discussion on db2 min, max, count functions are very slow within the DB2 forums, part of the Database Server Software category; --> I have a mid-size (60 mil records) table, it's taking almost 4 minutes to do a max of a ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 02:29 AM
| ||||
| ||||
 db2 min, max, count functions are very slow I have a mid-size (60 mil records) table, it's taking almost 4 minutes to do a max of a field, this is UDB V8.1 fp5 running on AIX 5.2, it's a P690 server w/ 16G of RAM and 24 processors, the same returns in < 10 secs in Informix, any help appreciated. Thanks, Rana      |
|
02-27-2008, 02:29 AM
| ||||
| ||||
| Re: db2 min, max, count functions are very slow rana ray wrote: > I have a mid-size (60 mil records) table, it's taking almost 4 minutes to do > a max of a field, this is UDB V8.1 fp5 running on AIX 5.2, it's a P690 > server w/ 16G of RAM and 24 processors, the same returns in < 10 secs in > Informix, any help appreciated. Thanks, Rana > > Create an index? Do runstats, ... |
Linear Mode
