Re: Problem query

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote:
> Shaun Thomas <sthomas@peak6.com> wrote:

>> What you really want is this:
>>
>> SELECT count(1) FROM (
>>    SELECT DISTINCT tds_cx_ind, cxs_ind_2
>>      FROM max_xtrv_st_t
>> );
>
> Or maybe:
>
> SELECT count(DISTINCT (tds_cx_ind, cxs_ind_2)) FROM max_xtrv_st_t;

Or maybe not.  I tried various forms of the query against "real"
tables here, and Shaun's format was ten times as fast as my last
suggestion and 12% faster than my first suggestion.

They all gave the same result, of course, and they all used a seq
scan..

-Kevin