Is the option to put the query in a job, which you schedule? A job
always runs in de serversite and will not give round trips.
Herald ten Dam
Superconsult
----------
Van: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx]
namens Vishal Gupta [vishal@xxxxxxxxxxxxxxx]
Verzonden: dinsdag 3 februari 2009 18:13
Aan: hkchital@xxxxxxxxxxxxxx; sjaffarhussain@xxxxxxxxx;
hkchital@xxxxxxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
Onderwerp: RE: Executing a query for the output without doing the
SQLNet round trips
Hemant,
If put an your query as inline view and do a count on non-indexed
column, then you will be able to all the physical/logical IO and
table accces (full or by rowid via index) in your query and can
avoid SQL*Net round trips. If this what you are after?
eg.
select COUNT(non-indexed-column)
from (
your query
);
Regards,
Vishal Gupta
<http://www.vishalgupta.com>http://www.vishalgupta.com
