Query processing is slow(eg select query)how will u solve that
Answer Posted / kumarayyalusamy
We will tune that query
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are statistics, under what circumstances they go out of date, how do you update them?
What is a system database and what is a user database? : 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
what is asm?
What are the different ways you can create databases in sql server? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
what is ora 24313?what is the procedure to exclude that error?
how can you enable flashback feature?
How would you extract DDL of a table without using a GUI tool?
which background process invoke at the time of upgradation tell me???
Why would you use sql agent? : 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.
What is transparent data encryption? : sql server DBA
Which autogrowth database setting is good? : sql server DBA