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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle, speed up query

Re: Oracle, speed up query

From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Thu, 22 Jul 2004 15:12:22 GMT
Message-ID: <qPQLc.107948$eO.96013@edtnps89>


Louis wrote:

> Hi everyone,
>
> I would like to say that i'm really new to Oracle. I started to read
> about it 1 month ago. I am currently writting an Excel application to
> query some data from an Oracle database. I use Excel 2002, OO4O
> 8.0.6.3.9 and Oracle 8.1.7.2.0
> I just want to retrieve data, nothing more.
>
> My question is about getting some help to speed up my query. I can't
> change the database so the optimization has to be in my code.
>

Do you have any indexes on those tables? How about statistics? How large are the result sets that you expect to return? Received on Thu Jul 22 2004 - 10:12:22 CDT

Original text of this message

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