Mladen,
you are too kind to the customer. I remember a book called 'Satisfaction
guaranteed', about customer satisfaction, which we oracle technical =
support
analysts in The Netherlands had to read in order to have any chance =
during
our yearly performance reviews.=20

I believe you are right, TRUNCATE TABLE is the best advise one can give
under these circumstances.. ..

Regards,
Andre


-----Oorspronkelijk bericht-----
Van: oracle-l-bounce@(protected) =
[mailto:oracle-l-bounce@(protected)]
Namens Mladen Gogala
Verzonden: dinsdag 15 maart 2005 21:32
Aan: oracledbam@(protected)
CC: oracle-l@(protected)
Onderwerp: Re: query tune

Seema Singh wrote:

>Hi,
>
>What changes required in below query to make faster?
>
> =20
>
The following command will speed the query up tremendously:

TRUNCATE TABLE URL_PAGES;

Executing this command will speed up the query for an order of =
magnitude.
You don't have to thank me. That is all I can help you with without =
knowing
the availability of indexes, distribution of data in the indexed =
columns,
size of the table and server version.

--=20
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l