Re: Any way to speed up this query?

From: Rick Bean (
Date: 10/05/04

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" <> wrote in message news:ATz8d.3368$
>I have a query that looks sort of like this:
> Select, table1.address, table,, 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?