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
- 2429 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 are the partitions types available in Oracle10g. How it will do? Simple example?
Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?
What are the different events in Triggers ?
What is the role of tables in database?
What do you understand by proactive, retroactive and simultaneous update?
What is system r?
What is the importance of database in an organization?
Define data, entity, domain and referential integrity?
What is ddl in dbms?
When do you get a .PLL extension ?
What is called dbms?
What are the different stages in 'data warehousing'?
-
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)
