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?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different sql server versions you have worked on? : sql server DBA
How would you determine who has added a row to a table?
What is blocking and how would you troubleshoot it?
What would you use to improve performance on an insert statement that places millions of rows into that table?
Explain the concept of the DUAL table.
WHEN DOWN TIME WHAT CAN U DO?
Why would you use sql agent? : sql server DBA
how can you process messages in order asynchronously?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
What is the difference between LMT & DLT?
which background process will run @ the time of creation of catalog database