Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Re: DB2 SELECT COUNT(*) problem

>Has anyone got problem with this on large table. It seems it take ages to
>return the result ( half an hour :-( ).
>
>SELECT COUNT(*) FROM COORDINATE
>

have you ran explain ? maybe an index would help

<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.