[pgsql-jp: 28209] Re: select count(*) performance

Thuy Nguyen thuy @ tndevelopment.com
2002年 12月 6日 (金) 14:26:40 JST


Hi, 


> 
> select count(ContentsCD) from tMailContentsF where AccountCD=_AccountCD_
>  and FolderCD=_FolderCD_;
> 

I am using this logic in another page.  However I still need to run

    select count(*) from tMailContentsF;

because I want to get all data.  ( I do not have where condition)

 




pgsql-jp メーリングリストの案内