Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / narmada kumari

Answers were Sorted based on User's Feedback



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

Answer / setaceo

1. DML Triggers to be DISABLED and then ENABLED once the
insert completed.
2. DISABLE the Clustered Index and then ENABLED once the
insert completed.
3. After completion of INSERT, Defragmentation should be
there.
4. After completion of INSERT, Statistics should be updated.
5. (Optional) If it is non-peek time & This is the only
activity is going on then, Database recovery mode should be
SIMPLE / BULK-LOGGED. ( It should not be there along with
other activities....)

Is This Answer Correct ?    4 Yes 0 No

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

Answer / braj123

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

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More DB Administration Interview Questions

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

What happens on checkpoint? : sql server DBA

0 Answers  

What the different components in replication and what is their use? : sql server DBA

0 Answers  

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

How do you resize a data file?

2 Answers  

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

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

0 Answers  

For more DB Administration Interview Questions Click Here
Categories