explain select count(*) from sq_logfile;
Not too helpful. Better choice is: explain analyze select * from sq_logfile;
Your explains show that selecting from view is 4 times slower than selecting from a table (35988:128282). It is possible.
Anyway counting 1 million rows usualy takes a long time...
Regards, Tomasz Myrta
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
