Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle, speed up query
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