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 All datafiles related to a Tablespace are removed ?
What is 1nf in database?
What are the features of openedge features?
What is the maximum size of the page ?
How to prevent firebird.log file from filling up the disk partition?
Write a query to remove duplicate rows from a table?
What is unique key example?
Explain ERASE packaged procedure ?
which is the best institute to learn Oracle DBA 10g/11g, please advise, someone?
How to change database dialect?
What you mean by Object Relational DBMS?
What is drivermanager getconnection?
Oracle (3253)
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)