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


Please Help Members By Posting Answers For Below Questions

What is openedge workgroup rdbms?

753


Define ddl and dml.

770


What are the key constraints in dbms?

696


How can you get the alternate records from the table in the sql?

712


What is query in database?

682


What is the database approach?

642


Explain the term ‘relations’?

639


What do you mean by denormalization?

704


Enlist some commands of ddl, dml, and dcl.

722


what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

1747


Define union all operator and union.

689


Define checkpoint.

682


What are the limitations of rdbms?

700


What is blob database?

634


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

2466