Re: query tune
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: oracledbam@xxxxxxxxxxx
- Date: Tue, 15 Mar 2005 15:32:12 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
