Pl. Advise in performance Tuning

[Kumar_RP]

Hi Folks,
We are writting PL/SQL procedures for warehouse project.. We have to take care about huge records in terms of lakhs...

But we are struggling in performance tuning part... Please advise about query optimisation.. How 2 optimize queries..

What types of tuning we have to opt for..
whether can we go for all rows, first rows, hash, indexing.. or any other stuff...

Please give ur valuable advise in this..
please send ur comments to...
palanir@sakinfotech.co.in

Eagerly waiting 4 ur reply...

Thanx in advance
bye
Palani Kumar. R

[tejal]

Hi,
Make use of a tool SQLabExpert which is available at http://www.quest.com
It is not free but you can download the trial version and use it.
This tool will advise you about the changes to be made in the query.
I found it very beneficial.

All the best !!
Tejal

Originally posted by Kumar_RP
Hi Folks,
We are writting PL/SQL procedures for warehouse project.. We have to take care about huge records in terms of lakhs...

But we are struggling in performance tuning part... Please advise about query optimisation.. How 2 optimize queries..

What types of tuning we have to opt for..
whether can we go for all rows, first rows, hash, indexing.. or any other stuff...

Please give ur valuable advise in this..
please send ur comments to...
palanir@sakinfotech.co.in

Eagerly waiting 4 ur reply...

Thanx in advance
bye
Palani Kumar. R

[hrishy]

Hello

You are looking for specific answers .you gotta givev us some specifics like the table structures..they query you r tryin to execute and the execuition plan of teh query only then we can help you.

regards
hrishy

P.S:a fool with a tool is still a fool

[satishpc]

hi,

we are doing something similar. for example, i have 2 tables.

t1 with fields t1f1, t1f2 .....
t2 with fields t2f1, t2f1 .....

t1 has around 2 lac records and t2 has 7 lac records. i want to update t1 with sum( t2f2) where t1f1 = t2f1. what will be optimal query ?

update t1 set t1f2 =
( select sum(t2f2) from t2 where t2f1 = t1f1)

but this runs fro a very long time. is there a better way to write this ?

satishpc