Problem query

Hi All;

We have a table with approx 200 columns. about a dozen columns are text
data types and the rest are a mix of integers , bigint's and double
precision types.

The table has about 25million rows.


The app wants to run a query like this:

select count(pri_num) from max_xtrv_st_t
where pri_num in (select max(pri_num) from max_xtrv_st_t where 1=1
                                group by tds_cx_ind, cxs_ind_2 )

I've tried to split the query up but made little progress, pri_num and
tds_cx_ind are bigint's and  cxs_ind_2 is an integer

The table has an index on all 3 columns (3 separate indexes)

Anyone have any thoughts on tuning this query?


--
---------------------------------------------
Kevin Kempter       -       Constent State
A PostgreSQL Professional Services Company
           www.consistentstate.com
---------------------------------------------