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 / 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 |
What are vdl and sdl?
what are the differences between network and hierarchical database model?
What are the types of distributed database?
Can we save file in database?
Explain the terms database and dbms?
What is hashing in dbms?
Is it possible to Disable the Parameter form while running the report ?
What do you mean by query evaluation engine?
What are Stored Procedures and When would we Use Them?
what Kind of COMMENT statements placed within SQL statements ?
What is Archived Redo Log ?
What is dbms and its functions?
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)