Re: query tune

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Tue, 15 Mar 2005 15:32:12 -0500
Message-ID: <4237464C.9000209@allegientsystems.com>

Seema Singh wrote:

>Hi,
>
>What changes required in below query to make faster?
>
>
>

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.

-- 
Mladen Gogala
Oracle DBA
Ext. 121


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

Received on Tue Mar 15 2005 - 15:35:50 CST