user says the db performance is slow or yesterday the query runned 1min and toda

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?

Question Posted / chandran

user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min...

Answer / 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

More Database Management Interview Questions

How to select a random record from a table?

Explain what are super servers?

What are the types of database explain each of them briefly?

What is a RADIO GROUP ?

How to activate all indexes in firebird?

What is data independence and also explain its types?

Is sql a rdbms?

describe middleware applications that ease the connection of databases to web?

What are the importance of database in banking?

Explain degree of a relation?

Define database lock and its types.

What are the disadvantages of a query?

For more Database Management Interview Questions Click Here