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
- 3064 Views
- HCL, I also Faced
- E-Mail Answers
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 |
Differentiate nested loop, hash join and merge join.
What versions of clipper does netlib support?
Oracle precompiler translates the EMBEDDED SQL statemens into ?
Write a note on File based system/ Data base system
What is dbms introduction?
What are different relationships existing in database?
Does netlib support windows 95?
Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?
how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping
what is candidate key & primary key,different b/t the two?
How can we tune a oracle database if log file sync issue comes
which is the best institute to learn Oracle DBA 10g/11g, please advise, someone?
-
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)
