Thread: count(*) index
View Single Post

   
  #1 (permalink)  
Old 04-17-2008, 09:19 PM
Tomka Gergely
 
Posts: n/a
Default count(*) index

Hi!

Yes, i know, mvcc, and can't use indexes. And i know the workaround for
max() and min(). Is there some workaround for count()?

select count(*) from table where field=1;

and field has a nice index. And this is slooooow.

--
Tomka Gergely
Tudom, anyu. Sapka, sál, doksi.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply With Quote