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 |
When connection to database is failed, Which exception will be thrown?
Can you explain insert, update and delete query?
What are the different types of modeling?
What is pdo in database?
What are the different types of keys in the database?
If CPU is very slow What can u do to speed up?
Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?
What is progress open edge?
How to specify transaction or query timeout?
What is vacuum in database?
Explain Relational Algebra in RDBMS
What are the benefits of database?
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)