How are the tables in data migration analyzed, and when does the analysis occur?
"The analyst managing a data migration process use statistics to analyze the tables in the data tables. They use the analyze command to perform this function. The information generated by analyze can also help to optimize how the data is retrieved and make the process more effective. The best time to analyze the tables is when the index table is first created or after the cluster is complete."
There is another technical question that contains two parts; the first being a how which is a process question the next being a when which is it clarifying question. You're reminded to answer every part of a question which an interviewer asks, especially with a technically-oriented interview. Doing this demonstrates both your listening skills as well as your attention to detail.
"The tables in a data migration process are analyzed by reviewing the statistics generated using the analyze command. The same statistics can be used by a cost-based optimizer to create a data retrieval plan. The analyze statement also supports the creation of the object's structures, space management, and other operations within the data warehouse tables. The tables are analyzed either when the index table is created or when the cluster is complete."
