Home » SQL & PL/SQL » SQL & PL/SQL » To make the query execute faster
To make the query execute faster [message #11084] Fri, 05 March 2004 01:28 Go to next message
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.
Re: To make the query execute faster [message #11086 is a reply to message #11084] Fri, 05 March 2004 02:22 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
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?
Re: To make the query execute faster [message #11088 is a reply to message #11084] Fri, 05 March 2004 02:36 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
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')
/
Re: To make the query execute faster [message #11089 is a reply to message #11086] Fri, 05 March 2004 02:42 Go to previous message
Nirene
Messages: 22
Registered: February 2004
Junior Member
I tried with Indexes now it is working fine.Thanks a lot Barbara
Previous Topic: To find wheather a index exist
Next Topic: ^L in first line in spool file
Goto Forum:
  


Current Time: Thu Mar 28 03:54:04 CDT 2024