Path: news.easynews.com!easynews!sjcppf01.usenetserver.com!usenetserver.com!nntpserver.com!hub1.nntpserver.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!news.xtra.co.nz!news.mel.connect.com.au!newshub1.rdc1.nsw.optushome.com.au!news1.rdc1.nsw.optushome.com.au.POSTED!not-for-mail From: nsouto@optushome.com.au.nospam (Nuno Souto) Newsgroups: comp.databases.oracle.server Subject: Re: any ideas for better performance of this query ? Organization: D.C.S. P/L Message-ID: <3bc454b1.5571577@news> References: X-Newsreader: Forte Free Agent 1.21/32.243 Lines: 24 Date: Wed, 10 Oct 2001 14:04:03 GMT NNTP-Posting-Host: 203.164.180.25 X-Complaints-To: abuse@optushome.com.au X-Trace: news1.rdc1.nsw.optushome.com.au 1002722643 203.164.180.25 (Thu, 11 Oct 2001 00:04:03 EST) NNTP-Posting-Date: Thu, 11 Oct 2001 00:04:03 EST Xref: easynews comp.databases.oracle.server:120818 X-Received-Date: Wed, 10 Oct 2001 07:47:58 MST (news.easynews.com) On 10 Oct 2001 07:00:26 -0700, minkuarora@yahoo.com (Parvinder Singh Arora) wrote: > > >10000 rows selected. > >Elapsed: 00:02:145.49 > what you are measuring this way is how long it takes to display the returned rows in your screen, not the speed of the query. > 451148 bytes sent via SQL*Net to client > 44937 bytes received via SQL*Net from client > 668 SQL*Net roundtrips to/from client ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ See? Cheers Nuno Souto nsouto@optushome.com.au.nospam