OraFAQ Forum: SQL & PL/SQL » To make the query execute faster

Home » SQL & PL/SQL » SQL & PL/SQL » To make the query execute faster

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To make the query execute faster [message #11084]

Fri, 05 March 2004 01:28

Nirene
Messages: 22
Registered: February 2004

Junior Member

Update TmpEffRep Set Stdhrs = (Select A.Flat_rate_hrs*60 From Lts A,Vin B,Ro C Where TmpEffRep.Ronum=C.Ronum and C.Regnum=B.Regnum and (B.Vcd=A.Vcd and Tmpeffrep.Opcd=A.Opcd))

TmpEffRep is a small with about 250 records but all the other tables have large no of datas.How do I boost the performance to get the result much more faster.

Report message to a moderator

Re: To make the query execute faster [message #11086 is a reply to message #11084]

Fri, 05 March 2004 02:22

Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA

Senior Member

Do you have indexes? Have you analyzed your tables, indexees, and indexed columns? Have you used autotrace to see what plan your optimizer has chosen?

Report message to a moderator

Re: To make the query execute faster [message #11088 is a reply to message #11084]

Fri, 05 March 2004 02:36

Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA

Senior Member

Please run the following and post the results on this thread.

SET ECHO ON
SELECT table_name, index_name, SUBSTR (column_name, 1, 30) AS column_name
FROM user_ind_columns
WHERE table_name IN ('TMPEFFREP', 'LTS', 'VIN', 'RO')
/

Report message to a moderator

Re: To make the query execute faster [message #11089 is a reply to message #11086]

Fri, 05 March 2004 02:42

Nirene
Messages: 22
Registered: February 2004

Junior Member

I tried with Indexes now it is working fine.Thanks a lot Barbara

Report message to a moderator

Previous Topic:	To find wheather a index exist
Next Topic:	^L in first line in spool file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 16 07:04:17 CDT 2025