What would you use to improve performance on an insert
statement that places millions of rows into that table?
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
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
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
how can you implement fine-grained auditing?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What types of replication are supported in sql server? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to start SQL Server in minimal configuration mode?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What would you do with an "in-doubt" distributed transaction?
Can you redefine a table online?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
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
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com