Write a code to pull-up mass data from one table and load into our rough table ? Written the code efficiently Again asked how to tune this code with performance efficiency. Answered correctly about more depth .

Question

Accepted Answer

Code to pull-up mass data from one table and load into another table efficiently

Use INSERT INTO SELECT statement to pull data from source table and load into target table
Use WHERE clause to filter data if required
Use INDEXES on columns used in WHERE clause to improve performance
Use BULK COLLECT to fetch data in batches to improve performance
Use PARALLEL hint to execute the query in parallel if the table is large
Use NOLOGGING option to improve performance by reducing redo log generation

Asked in SunTec Business Solutions

Write a code to pull-up mass data from one table and load into our rough table ? Written the code efficiently Again asked how to tune this code with performance efficiency. Answered correctly about more depth .

Interview Questions Asked to Plsql Developer at Other Companies

Top Skill-Based Questions for SunTec Business Solutions Plsql Developer