Re: Any way to speed up this query?
From: Rick Bean (rgbean_at_unrealmelange-inc.com)
Date: Tue, 5 Oct 2004 16:15:47 -0400
I'm just curious why you need this table. Are you moving the data to another system, or are you just using it for a query or report? If you just want to "browse" or report on the resulting rows, then just using both tables with a relationship should suffice. (I am assuming that this is a 1-1 relationship otherwise you might be pushing the 2gb max table size for the resultant table.)
"Kathy Weise" <firstname.lastname@example.org> wrote in message news:ATz8d.3368$UP1.email@example.com...
>I have a query that looks sort of like this:
> Select table1.name, table1.address, table,1.city, table1.state,;
> [and several more fields from table1], table2.a, table2.b, table2.c;
> from table1, table2 where table1.seqno = table2.seqno;
> into table3
> I have seqno indexed on both tables (both numerical and both 10 characters).
> Each table is close to1 Gb. The query takes 2 hours (if I haven't just
> defragged my HD which helps a little).
> Is there anyway to speed this up?