user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?
Answer Posted / basanti
1. Check the volume of data.
2. check whether index need to be rebuild or not.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is openedge workgroup rdbms?
Define ddl and dml.
What are the key constraints in dbms?
How can you get the alternate records from the table in the sql?
What is query in database?
What is the database approach?
Explain the term ‘relations’?
What do you mean by denormalization?
Enlist some commands of ddl, dml, and dcl.
what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000
Define union all operator and union.
Define checkpoint.
What are the limitations of rdbms?
What is blob database?
Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com