Re: Oracle Performance

Why don't you post the query SQL for us to take a look at -

lisa.bogart_at_eds.com wrote:

> I am not an Oracle person - just an application developer - but my DBA is
> seriously overworked and I am hoping someone can give me some clues to a
> performance problem I am having. I have a select that joins together 4
> tables that each contain about 150000 - 300000 records. The select only
> returns about 55 records, however. The problem is that when I run the select
> anywhere (my app, SQP-Plus, ODBC Test) I get almost instantanious response at
> first but then after it has gottn most of the data, it chokes for over a
> minute before it gets the last few records. The problem is that I am trying
> to create a disconnected recordset in a VB component running in MTS. With a
> disconnected recordset, it gets all the data at once so my performance is
> horrible. Can anyone point me in the right direction?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed May 05 1999 - 09:33:35 CDT