WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
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
Explain environment of openedge?
What is entity relationship diagram?
Segregate database technology's development.
Explain what are called fat clients and fat servers?
What is the full form of rdbms?
How to unzip a file in ssis?
What is database host?
What is type of end users?
What is optimization in database?
Enlist the advantages of dbms.
When does checkpoint occur in dbms?
Define view, sequence and index in DBMS.
1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?
What is sql and where is it used?
Explain the importance of partitioning.