Interested to Buy Any Domain ? << Click Here >> for more details...
WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
- 4 Answers
- 8566 Views
- CTS, iNautix, TCS, I also Faced
- E-Mail Answers
Answer Posted / muzaffar ali umrani
first check is there any index created in on that table, if yes then arrange your query according to index and check its execution plan and if there is no index on query then create the index.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the four components of a database system?
Why is the use of dbms recommended? Explain by listing some of its major advantages.
Write a query to create a duplicate table with and without data present?
What is n tier architecture in dbms?
How do you create a report in a database?
What is a 3nf table?
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?
Is dynamodb a document database?
Explain about the case statement present in stored procedure?
What is a checkpoint in dbms and when does it occur?
What is dbms architecture?
Explain the use of assign statement in progress database?
i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........
Why is the use of dbms recommended?
Compare a hierarchical and network database model?
