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 -> VB.net front end / slow queries

VB.net front end / slow queries

From: Ann via OracleMonster.com <forum_at_OracleMonster.com>
Date: Thu, 24 Feb 2005 17:16:07 GMT
Message-ID: <08eade3c6b79410a81cfe1b40733f617@OracleMonster.com>


I am a VB.net developer and not a dba... I'm developing a VB.net application with an Oracle database backend

Is it better to use a view in the database for a query that will be repeatedly accessed, or a stored procedure?

Does a view have an execution plan in Oracle?

Does a stored procedure have an execution plan in Oracle?

I am accessing the Oracle database via a VB.net application and have set up views to make the database do some of the work. Will that help speed up the query?

Right now, there are 1.8 million header records joined on 4.2 million detail records. I created a the equivalent of a crosstab query using case statements to make one transaction reconrd via a view. And, the query takes about 15 minutes to run???

There are indexes on the primary keys in both tables.

Any help in speeding up these queries?

To complicate things, I have a dataset linked to a crystal report to display the data, and so the results don't display until the query results are totally completed. This will be very frustrating to the end user. And the user inputs a date range as parameters. Obviously, the larger the date range, the longer the query takes to run...

All Oracle Gurus please Help! And, thanks in advance.

-- 
Message posted via http://www.oraclemonster.com
Received on Thu Feb 24 2005 - 11:16:07 CST

Original text of this message

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