Master 30 Oracle Performance Tuning interview questions covering SQL optimization, indexing strategies, and execution plans.
Question 9 of 30
Why the Interviewer Asks This Question
How to Answer
Example Answer
Community Answers

William Swansen has worked in the employment assistance realm since 2007. He is an author, job search strategist, and career advisor who helps individuals worldwide and in various professions to find their ideal careers.
When an interviewer asks you about the best way to accomplish a task, they are really asking for your opinion. Most tasks have several different options which can be used when performing them. The interviewer wants to understand which of these options you use and whether this follows industry standards, generally agreed upon methodologies, or the process currently used by their organization.

William Swansen has worked in the employment assistance realm since 2007. He is an author, job search strategist, and career advisor who helps individuals worldwide and in various professions to find their ideal careers.
Since this question asks you about your opinion on the most direct way to collect statistics on a database table, your answer should reflect your expertise and experience performing this task. It is very likely that you follow generally accepted, agreed-upon methodologies. Your answer should reflect what the interviewer is expecting. However, this also provides you the opportunity to demonstrate your innovation by describing something recently developed or which is being adopted as a new standard for the industry. Regardless of how you answer the question, you should be prepared for a follow-up question asking you to discuss your rationale for using the method you described in your answer.

William Swansen has worked in the employment assistance realm since 2007. He is an author, job search strategist, and career advisor who helps individuals worldwide and in various professions to find their ideal careers.
"The most direct way to collect statistics on a database table is to use an init parameter to designate one of two methods used to collect the statistics. These are compute and estimate. The format of the init parameter is 'analyze table emp compute statistics' or 'analyze table emp estimate statistics'."

Interview Coach
Jaymie
A real coach, not AI. I read every answer myself and write back with personalized feedback.
Typically responds within 24 hours.
0 - Character Count
Unlock expert responses to complex tuning scenarios that database architects evaluate.
Get StartedJump to Question

Written by William Swansen
30 Questions & Answers • Oracle Performance Tuning

By William

By William