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: Mark <mstern_at_xtra.co.nz>
Date: 28 Feb 2005 03:51:47 -0800
Message-ID: <91b87c58.0502280351.17f9ea2c@posting.google.com>


Some thoughts (from a fellow developer and not a DBA), probably best executed in the order listed.

Have you calculated statistics on the database lately (or at all).

Add indexes to the fields included in the case statements (maybe add and test, then remove and test others, strange things can sometimes happen, adding unneccessary indexes can actually decrease performance in some cases)

Look at the Auto Trace statistics to see if you have the server memory configured appropriately (I use TOAD, which has a nice little tab to display them).

Do a google search of this, and the other, oracle new groups for hints. Or do a general google search.

Read other articles/white papers on optimising queries.

Hire an Oracle guru.

If any of the above help, then feel free to send me an appropriate consulting fee to my Swiss Bank Account (just joking <grin>), but a couple of beers never go amiss!

Good luck.

Mark

"Ann via OracleMonster.com" <forum_at_OracleMonster.com> wrote in message news:<d7f9a4b03ff74756a0b9a0991e3e73d2_at_OracleMonster.com>...
> 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.
Received on Mon Feb 28 2005 - 05:51:47 CST

Original text of this message

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