RE: query tune
- From: "Andre van Winssen" <awinssen@xxxxxxxxx>
- To: <mgogala@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 15 Mar 2005 22:00:49 +0100
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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Namens Mladen Gogala
Verzonden: dinsdag 15 maart 2005 21:32
Aan: oracledbam@xxxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
