Query processing is slow(eg select query)how will u solve that
Answer Posted / jayesh
WE CREATE PROCEDURE THEN ACCESS IT
INDEXING ALSO DONE
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
how can you enable flashback feature?
what is a user-defined lock?
What is a system database and what is a user database? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is replication? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Why would you call update statistics? : sql server DBA
what is a crs resource?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What are statistics, under what circumstances they go out of date, how do you update them?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What happens on checkpoint? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
how can you process messages in order asynchronously?