Interested to Buy Any Domain ? << Click Here >> for more details...
WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
- 4 Answers
- 8703 Views
- CTS, iNautix, TCS, I also Faced
- E-Mail Answers
Answer Posted / deepak soni
if you talk about sql you should create clusterd index
but in oracle you have to create indexes to improve the
performance of query or you can say retrive the data in
faster rate.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the main features of a database?
How can I access my database remotely?
What are 3 types of databases?
What are the main functions of a database management system?
What are the two types of database?
What is service based database?
Which database server is best?
What are the steps to follow when preparing to create a table?
If you need to refresh a website page every time a record is updated in database, how would you do it?
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
Define stored procedures.
Explain what are service-specific middleware?
what is the difference between two and three-tier architectures?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
What is the role of database management system?
