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

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 .

Popular interview questions of Plsql Developer

Top HR questions asked in SunTec Business Solutions Plsql Developer