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
- 3100 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 |
Describe concurrency control.
What is rdbms architecture?
What is a checkpoint in dbms and when does it occur?
What is difference between database and file?
How do you create a database?
wHAT IS THE difference between foreign key and reference key
What is system r? How many of its two major subsystems?
How many types of data are there?
What is a hierarchical database?
Explain concurrency transparency.
Mention the differences between the clustered and non-clustered index
what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000
0 Answers Indian Web Technology,
-
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)
