quick easy question, Please Answer

Basically my question is, whether it would be faster to query 4 tables (each with about 5000 rows) with query like this: select count(*) from table where rid=number; with table having an index on rid.

or faster to query one table (with about 20,000 rows) like this: select count(*) from table where rid=number and time=varchar[8]; I would make an index on this table with (rid,time) or 2 indexes, one with rid, the other with time.
Let me know, thanks.
James Thomson
itabl7up_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 26 1999 - 11:03:47 CDT