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
- 3103 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
How to repair a corrupt firebird database?
Explain ddl interpreter?
What are the different types of modeling?
What is a clause in terms of sql?
Which is fastest database?
What is database users in dbms?
1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?
What is the purpose of using a model?
Describe the difference between embedded and dynamic sql.
Why not phenix, the zelinka/otwinoski libraries, etc?
Explain the concepts of a primary key and foreign key.
What is alternate key?
How many types of database languages are?
What are the types of model?
What is sql in database management system?
