Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 3091 Views
- HCL, I also Faced
- E-Mail Answers
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
Why do we need database management?
Explain the importance of database partitioning.
What is dbms architecture?
How do you rename a database?
What is rdbms data?
What do you mean by buffer manager?
What is primary key in database?
What are the various Database states.
What is a relation in dbms?
How to stop superserver service on linux using only firebird tools?
Where is database stored?
How do I keep my database up to date?
Categories
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
