Search Again: Re: Dead slow count(*) From: =?iso-8859-1?q?nihraw=20jalal?= Date: Thursday, January 29, 2004 Time: 4:27:57 pm Hi Jordi, If you do not have a where close it should not take that long, no more than several minutes depending on your settings, while if you have a where close, try to create an concatenated index on all columns in your where close. Sometimes analized tables in the CHOOSE mode behave like this. Try the RULE mode. Regards Nehro --- Jordi Adame V <jordi@inffinix.com> wrote: > Hi! >=20 > I have this table with ~4,000,000 entries >=20 > When i do a SELECT COUNT(*) FROM TABLE_NAME >=20 > it takes 4 hours to give me the result, this is way > too much >=20 > Im running Oracle 9.2.0.4.0 on RedHat AS 3 >=20 > These are my first experiences with Oracle, so I > have no clue how to fix this=20 > query time... Any help would be nice >=20 > regards >=20 > Jordi >=20 > ---------------------------------------------------------- > To subscribe, unsubscribe or to search list archive > please visit > http://www.digitalpoint.com/lists/oracle.html > ----------------------------------------------------------=20 =09 =09 =09 ___________________________________________________________ BT Yahoo! Broadband - Free modem offer, sign up online today and save =A3= 80 http://btyahoo.yahoo.co.uk ---------------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.digitalpoint.com/lists/oracle.html ----------------------------------------------------------

Messages In This Thread: Dead slow count(*) by Jordi Adame V on Jan 29, 2004 at 2:39:04 pm Re: Dead slow count(*) by =?iso-8859-1?q?nihraw=20jalal?= on Jan 29, 2004 at 4:27:57 pm