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
- 3217 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 |
What is a relation schema?
What do you understand by query optimization?
How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
What is a key in database?
What are the advantages of a database?
What restrictions can you apply when you are creating views?
What is the 3-tier architecture?
Explain why an information gap exists in most organizations.
What do you understand by sub-queries in sql?
What are views in dbms?
What is the use of CONSISTENT (Ver 7) option in EXP command ?
How to pump the data from one database to another?
-
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)
