Interested to Buy Any Domain ? << Click Here >> for more details...
What would you use to improve performance on an insert
statement that places millions of rows into that table?
- 2 Answers
- 6076 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How do you trace the traffic hitting a sql server? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what are the performance views in an oracle rac environment?
Query processing is slow(eg select query)how will u solve that
how can you connect from 10g user to 11g user??
how can you create a user-defined lock?
what is the role of dip user in our database?
What is dcl? : sql server DBA
how can a session indicate its interest in receiving alerts?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what is a crs resource?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
how can you implement fine-grained auditing?
