Re: Optimizing Query

From: Colin <colinwinning_at_yahoo.com>
Date: 23 Oct 2001 02:17:15 -0700
Message-ID: <8181cd1e.0110230117.70bc91ee@posting.google.com>

Hi Herman,

See comments inline

h.de.boer_at_itcg.nl (Herman de Boer) wrote in message news:<bde5777e.0110221000.7bf1afcd_at_posting.google.com>...
> Hello Colin,
>
> 1. please post the complete procedure.

Not sure what you want in the way of a procedure.

> 2. how many rows will be returned by the query (without the rownum) ?

The query currently returns in the region of 200,000 rows (without the rownum). The idea is that whenever a row is processed, the processed flag is updated so that it will not be returned again in following queries. This way, batches of records can be processed at one time. The number of rows returned, should therefore decrease all the time.

>
> Kind Regards,
>
> Herman de Boer.
Received on Tue Oct 23 2001 - 04:17:15 CDT