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
- 2404 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 |
Define RDBMS.
0 Answers Ernst Young, Thomson Reuters,
What is the difference between primary key and secondary key?
0 Answers Axtria, ITC Indian Tobacco Company,
What do you understand by index hunting?
Is database a data structure?
What are different relationships existing in database?
What is dbms function?
When connection to database is failed, Which exception will be thrown?
How do you create a database?
What are different types of data models?
Can an Alert message be changed at runtime ?
Explain dml (data manipulation language)?
Which database is best for large data?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
