[SQL] Select very slow...

[Fernando Eduardo B. L. e Carvalho]

    Table  1

    create table person (

                 doc text primary key,

                 etc ....

                 city  text  );

   90000 rows

   create table sales (

                 doc text,

                  etc .....

                  );

   300000 rows

  select  p.city,count(*) from sales s, person p where s.doc = p.doc
group by p.city;

   Anyone help-me?





---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]