Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: VB.net front end / slow queries

Re: VB.net front end / slow queries

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 25 Feb 2005 16:48:56 +0100
Message-ID: <cvnh94$tlt$1@news3.zwoll1.ov.home.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US