En cours

Oracle query rewrite- performance

Need help in rewritting Oracle Query

Please read carefully and bid if you can comply following :

Will pay @60-70 USD by paypal

Must finish rewrite (considering performance) in next 8 hours. I need it by 10 AM EST tomorrow.

Must be available for answering questions (I may have)

Document the findings

I will send the actual query to the winner.

Answer the following question :

What will be your approach if you are asked to to rewrite/tune following query? temp has 25000 records.

---------------------------------------------------------

PROCEDURE load(xyz VARCHAR2)

FOR rec IN (SELECT * FROM temp)

LOOP BEGIN

SELECT b_id INTO vCId

FROM bl fb

..

..

INSERT INTO ab l

( col1,col2)VALUES('abc',[url removed, login to view])

IF count = 1000 THEN

COMMIT;

count := 0;

END IF;

count := count + 1;

End Loop;

End load

Compétences : MySQL, Oracle, SQL

Voir plus : sql to oracle, procedure sql oracle, n query, oracle tune, oracle performance, sql l, send query, rec, bl, sql query loop, query loop, oracle loop query, rewrite sql, sql question, query performance, sql paypal questions, oracle select query, document must rewrite, sql query help, loop send, oracle procedure, need help usd, temp2, rewrite questions answer, sql temp insert oracle

Concernant l'employeur :
( 12 commentaires ) Toronto, Canada

N° du projet : #2372638

Décerné à :

ziggyfish

I have a lot of experience with Oracle and have done a lot of query optimization for big and small businesses. I have built OLAP systems that have over 1 TB of data in the database. The answer to your question is Plus

100 $ USD en 1 jour
(4 Commentaires)
2.9

9 freelance ont fait une offre moyenne de 106 $ pour ce travail

Codoc1010

Hi, i am ready for your job. Please view my message for detail. Thanks!

70 $ USD en 1 jour
(24 Commentaires)
5.0
mslien

Hi. I ready to work on your requirements.

50 $ USD en 1 jour
(2 Commentaires)
3.0
bouslimi1979

Please check PM. Thanks

70 $ USD en 1 jour
(1 Commentaire)
2.9
kkolukul

Having 6+ yrs of experience in sql/plsql and other Oracle technologies. Will finish your work in good quality.

60 $ USD en 1 jour
(2 Commentaires)
2.6
Alld

hi, i m ready to do this job.

240 $ USD en 10 jours
(1 Commentaire)
1.0
wijman

Hi, Well I'd start by removing the useless loop. There are hardly ever any good reason to use loops... For an immediate speed boost I'd just change your COMMIT to "COMMIT WRITE BATCH NOWAIT;" The above line t Plus

250 $ USD en 1 jour
(0 Commentaires)
0.0
mirrorseiva

Hi, I dont think you need anybody's help. Remember that issuing commits too often might cause ORA-1555 snapshot too old error when try to recover. If i were you, i would create an index and make sure my query an Plus

50 $ USD en 1 jour
(0 Commentaires)
0.0
pkdn00

Over 20 years experience in Oracle Development, DBA and Performance Tuning. In this case the number of records committed can be tuned and the SELECTs can be indexed / optimizer hints. Also Bulk SQL can be considered. Plus

60 $ USD en 2 jours
(0 Commentaires)
0.0