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
- 3013 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Mention some disadvantages of query?
What is the purpose of normalization in dbms?
What is difference between database and server?
What are the basic components of notification services?
Explain snapshot replication.
Explain the importance of partitioning.
What is rdbms data?
Mention some advantages of using dbms.
What is data in dbms?
Is dynamodb a document database?
Describe the differences between vertical and horizontal portioning.
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?
What are the basic functions of a database?
What are the advantages of dbms?
How to implement a database management system?
