GeekInterview.com
Series: Subject: Topic:
Question: 3 of 291

Performance improvement in Bulk Collect

What is the amount of performance improvement you get with doing BULK COLLECT? I tried answering I will measure with the cost.. but the interviewer wants a specific answer. Is there any general formula for deriving the cost improvement based on the no. of records processed in bulk fetch?
Asked by: Jamuna_J | Member Since Jul-2012 | Asked on: Jul 6th, 2012

View all questions by Jamuna_J

Showing Answers 1 - 1 of 1 Answers
dinesh

Answered On : Feb 3rd, 2013

We can limit the bulk binding values. It would improve the overall performance. It would not consume more memory.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Database Administration

Interview Coaching

What are the career opportunities available for MCA Graduates?

How do you handle pressure and stress?

What is the role of a mechanical engineer in the Software Industry?

Has there been a time when you were presented a problem and solved it?

Career Options for BCA Graduates

Do you like working in a team or alone? Explain.

Does a problem make you a better person?

Describe a time when you had to listen to someone.

Aptitude Test Preparation Tips

What are the career options available in Software Testing Industry?

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Oracle DBA FAQ

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe