Check that any indexes are there. Drp the indexes and recreate after inser

What would you use to improve performance on an insert
statement that places millions of rows into that table?

Question Posted / braj123

Answer Posted / braj123

Check that any indexes are there.
Drp the indexes and recreate after insert.

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2372

how can you schedule a job in database?

1043

What are the different sql server versions you have worked on? : sql server DBA

963

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2407

Where would you look for errors from the database engine?

2789

What is the importance of a recovery model? : sql server DBA

966

what are the differences of where and if in SAS?

2132

Which autogrowth database setting is good? : sql server DBA

1053

what is ora 24313?what is the procedure to exclude that error?

2518

what are the types of connection load-balancing?

934

What authentication modes does sql server support? : sql server DBA

1135

How would you extract DDL of a table without using a GUI tool?

2440

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1867

how can you enable flashback feature?

893

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1028