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 do you mean by DBMS?
What is inner join in database?
What is database write application of database?
Explain the components of rdbms?
Explain what is meant by asymmetrical protocols?
What is difference between database and spreadsheet?
Should database table names be capitalized?
What are five advantages of a database?
How do you call a stored procedure from jdbc?
What are the advantages of database management system?
Why normalisation is required?
What is the difference between primary key and secondary key?
how to solve cardinality in dbms...many to many ralationships
What is 2nf in dbms?
What is dba stand for?