RE: query tune

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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
Namens Mladen Gogala
Verzonden: dinsdag 15 maart 2005 21:32
Aan: oracledbam_at_hotmail.com
CC: oracle-l_at_freelists.org
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