Re: NEED: more Effiency

Two ideas:

1. Check the indexing on the tables. Make sure indexes are being used rather than full-table scans.
2. It might actually work better to use a single SELECT with a real big join. Indexing applies here too.

Good luck,
Dave

Seth E. Broomer wrote in message ...
>
>Hi,
> I am querying about 10 tables that through one way or another are
>related to each other, My total amount of records that I'm extracting
>from all of these tables are aroud 500,000. Right now I pull as many
>records as i can from one table to set up all the other relations. I then
>use cursors to fetch the other records in the other tables into my new
>table and update those records,
>
>It takes days to do 500,000 records. How can I make this process go
>faster?
>
>thanks
>
>seth
>
Received on Mon Aug 17 1998 - 18:26:35 CDT