Make a summary table and select from there instead.
Ken
On Fri, May 18, 2007 at 06:15:25AM -0700, Jessica Richard wrote:
> I have a ~30 milliow row table, select count(*) from this table is very very
> very slow...
>
> How dow I get it run faster?
>
> Thanks,
> Jessica
>
>
> ---------------------------------
> We won't tell. Get more on shows you hate to love
> (and love to hate): Yahoo! TV's Guilty Pleasures list.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
