Adam wrote:

> feature that is pointless). If you don't want any records, don't run
> the query. If you must run the query to get an empty results, then
> use the PK index to eliminate all possible records.
>

I appreciate your help, but it seems my original question was not answered which
could be stated as,
is there any advantage of preparing a cursor using the second query if only
insert but no fetch will be done.

regards,
bill