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)
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
count := 0;
count := count + 1;
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
9 freelance font une offre moyenne de $106 pour ce travail
Having 6+ yrs of experience in sql/plsql and other Oracle technologies. Will finish your work in good quality.
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
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
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