Re: any ideas for better performance of this query ?

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Wed, 10 Oct 2001 14:04:03 GMT
Message-ID: <3bc454b1.5571577@news>

On 10 Oct 2001 07:00:26 -0700, minkuarora_at_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_at_optushome.com.au.nospam Received on Wed Oct 10 2001 - 09:04:03 CDT