Ann via OracleMonster.com wrote:
> Thanks for your kind reply.
>
> "Filed" in the second select statament is a typo in my post, but it is correct in the code.
>
> Yes, field one is the primary key in both tables. There is an index on field 5. I select all records explicitly naming each field in my select statement in the VB code.
>
> The query is using the index on table a which includes header records, and it is not using the index on table b which includes detail records. It is doing a full table scan on the detail table.
>
Looks like the fastest way to me.
You will have to run statspack and see if it is Oracle, or the
reporting tool you're waiting for.
--
Regards,
Frank van Bortel
Received on Fri Feb 25 2005 - 09:48:56 CST
