RE: query tune

MG -

Why not go all the way...and squeeze EVERY LAST DROP of performance out = of this query?

TRUNCATE TABLE URL_PAGES drop storage;

I don't understand why some DBAs just don't "cross all the T's and dot = all the I's"

Yours in Performance,=20

etc.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Tuesday, March 15, 2005 3:32 PM
To: oracledbam_at_hotmail.com
Cc: oracle-l_at_freelists.org
Subject: 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